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

Would you like to answer or comment?

Sign up for a free account, or sign in (if you're already a member).
Answer this question

Topics:

,
  • # Posted 1 year ago
  • 866 views
Share Send to a friend Watch Report
 
 

Posted Answers

Order by
 
boots
9 answers
8 thumbs up

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 1 year ago ( permalink )
In reply to Eyespi's question
Rated as
Best Answer
0
1
  Report Abuse  

Helpful?

line
line
line



 

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 1 year ago ( permalink )
In reply to boots's answer
Rated as
#3 out of 4
0
0
  Report Abuse  

Helpful?

line
line
line



 
erez_ny
1 answer
1 thumb up

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 1 year ago ( permalink )
In reply to Eyespi's question
erez_ny was invited by Yedda to answer this question.

Rated as
Best Answer
0
1
  Report Abuse  

Helpful?

line
line
line



 

Thank you Erez.

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

 

Margaret
Posted 1 year ago ( permalink )
In reply to erez_ny's answer
Rated as
#4 out of 4
0
0
  Report Abuse  

Helpful?

line
line
line



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:


Present Value in Excel

What is the formula for finding Present Value in Excel?
Submitted by Pardess 2 years ago
  • 1 answer
  • viewed 1859 times

Last answer posted 2 years ago by yoavdothan


How to do excel

how to do excel
Submitted by bomber78963 3 months ago
  • 1 answer
  • viewed 148 times

Last answer posted 3 months ago by sammythebomb


Excel is causing problems on my PC

I've done an uh-oh with Excel. Everytime I try to open ANY program, including add/remove programs or any program in the "Start ...
Submitted by Bullwhip 3 months ago
  • 1 answer
  • viewed 106 times

Last answer posted 3 months ago by sammythebomb



» More...

Explore Related Posts in Forums

  • VBD Spreadsheet App - Footballguystalk

    ... VBD Spreadsheet App - Frequently Asked Questions 1) The VBD only shows the top 60. How can I show my league variables and scoring settings each time I update the VBD Spreadsheet. Open your Previous - more...

» More...

Powered by:

Omgili
Feed - Subscribe to changes to this Q&A Blog