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
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.
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.
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
The search for people who can answer your question continues for as long as needed - until you find the answer you were looking for.
When an answer is posted by someone who was invited (byYedda or by yourself) to answer your question, their answer is marked with a yellow "invited by Yedda".
To be invited to answer other people's questions in your areas of knowledge and interest, be sure to list your favorite topics:
» My Settings › My Topics.
Of course, the more helpful your answers are, the more likely you are to be invited to future questions...
Thank you Erez.
I ended up importing the spreadsheets in to Access and did it via SQL update statements.
Got an answer for Eyespi? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
Other people asked questions on various topics, and are still waiting for answer. Would be great if you can take a sec and answer them
