Excel 2007 – formula or macro to show value from one cell next to a given reference

Tags:
Excel 2007
Microsoft Excel
Microsoft Excel macros
Hope someone can help I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG - Sheet 1 has a cell with £500 in cell 3A The reference 1.01 is located in cell 3B On Sheet 2 i need to show the value of 3A in a cell, say 5A, by inputing an instruction that will look at the whole of column B on sheet 1, find the reference 1.01 and then apply the value of 3A into cell 5A on that sheet - ie sheet 2 I am working on figures imported into excel and then I am apply a reference manually

Answer Wiki

Thanks. We'll let you know when a new response is added.

Take a look at this <a href=”http://www.cpearson.com/excel/topic.aspx”>great Excel formula resource</a>
********
Have you explored VLOOKUP capabilities? You may have to shift the columns to start the lookup number followed by the value. In other words A3 will have 1.01 and B3 will be 500.
So set up the table with all lookup values in col. A and then corresponding number in col. B.
On Sheet 2, on cell A5 use =VLOOKUP(lookup number,Sheet1!A3:B50,2,FALSE). If you want to get a perfect match. Or use =VLOOKUP(lookup number, Sheet1!A3:B50,TRUE) – will get the number equal to less than matching number.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following