Posted by Eyespi 5 years ago In:

,

Eyespi
Eyespi Asked:

I need to create an excel formula in a spreadsheet ...

i need to create an excel formula in a spreadsheet that compares values from sheet1.column a to sheet2.column b and returns the value from sheet2.column c to sheet1 column c

 

Thanks in advance for your help.

Margaret

Liked this question? Tell your friends about it

4 Answers

Order by
Oldest to Newest
Newest to Oldest
Votes
boots
boots Answered:

I didn't quite understand your question, but in Excel addresses are not limited to just columns and rows, you can type in the sheet name, for example:

=Sheet1!A1-Sheet2!B1 

Will give you the difference between the value of cell A1 in sheet1 and the value of cell B1 in sheet2.

Add a comment Report
Eyespi
Eyespi Answered:

My sheet1 contains model and serial numbers of equipment in my customer base. There are some 30,000 combinations. My sheet 2 contains model numbers and a code for each one. There are only about 600 different model numbers.

I want to match the model numbers from the two sheets and report the code for the model on the sheet with the serial numbers.

I've tried if sheet1.colA=sheet2.colB then sheet2.colC else "z", but I get more Z's than codes.

 

Hope this makes it more clear for you.

Thanks for your help.

 

Margaret

Add a comment Report
erez_ny
erez_ny Answered:

Hi,

It is not simple to understand the problem, but if I understand correctly, you might want to use vlookup function to look in the DB for the model and find its code.

Erez

Add a comment Report
Eyespi
Eyespi Answered:

Thank you Erez.

I ended up importing the spreadsheets in to Access and did it via SQL update statements.

 

Margaret

Add a comment Report

Related Questions

Other people asked questions on similar topics, check out the answers they received:

Scott

Asked: Deleting page in Excel

how do I delete a single page in an excel spreadsheet
  • Posted by Scott 3 years ago
edwardt

Asked: Lost sheets in my spreadsheet and date not entered ...

I have ms office excel2007. I have lost my sheet 1, 2 3 and 4 the main spreadsheet is there but the sheets are gone. They must be there and hidden somehow???? Somewhere?? Also i noticed last ...
Carol Spetzman

Asked: Create a 6 month roll up Jan-June'08 absence ...

I need to create a 6 month roll up Jan-June'08 absence worksheet by type of absence using Excel for each employee. I have excel worksheets for each month listing all employees and the reasons for ...