• Answers
  • Web
Personalize Yedda, (And make Danny Happy)
People ask & answer about almost everything. Tell us what you're interested in... So we can personalize Yedda especially for you
I'm interested in:
Save
Cancel

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


Answer this question

Topics:

,
Share Send to a friend Watch Report
 
 

4 Posted Answers
Order by

 
9 answers
4 helpful answers

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.

Posted 2007-04-11T15:20:06Z
Helpful?(1)
Rated as Best Answer
 

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
Posted 2007-04-11T15:28:14Z
Helpful?(0)
Rated #3 out of 4
 
1 answer
1 helpful answer

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
Posted 2007-04-11T18:15:28Z
erez_ny was invited by Yedda to answer this question.

Helpful?(1)
Rated as Best Answer
 

Thank you Erez.

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

 

Margaret
Posted 2007-04-11T18:19:37Z
Helpful?(0)
Rated #4 out of 4

Sign in to participate

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).

Explore Related Questions

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


Q:

Sample Succession PLans in Excel FOrmat

Does anyone have ideas for excel sheet for succesion plans?
Submitted by careymm   4 months ago.
  • 0 answers
  • viewed 170 times
Be the first to answer


Q:

VB script for Excel spreadsheet printing

I wish to write a vba script I can run for a spreadsheet in MS Excel that only prints only the rows for a column (let's say ...
Submitted by JtotheA   2 years ago.
  • 1 answer
  • viewed 2086 times
Last answer posted 2 years ago by JtotheA


Q:

Lost sheets in my spreadsheet and date not entered on spreadsheet properly

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 ...
Submitted by edwardt   4 months ago.
  • 1 answer
  • viewed 64 times
Last answer posted 4 months ago by SpreadsheetsDirect



» More...

Feed - Subscribe to changes to this Q&A Blog
ADVERTISEMENT
  • Answers
  • Web
Copyright © 2006-2009, Yedda Inc. and respective copyright owners · CC License