Excel Question - Looking up a value

[EllieFant]

I do not work in Excel much but a co-worker approached me with a question and needs an answer - I am sure it is easy for those that work in Excel.

He has a Excel Workbook (in Excel 97) and on the worksheet he wants to be able to have a value in a cell and be able to automatically insert a number (from a different sheet in the same workbook).

For example if Cell B9 on worksheet 1 = 90%, he wants to look on worksheet 2, find 90% in Column A (say it is A24) and insert the value found in Column B (B24) in cell B10 on worksheet 1.

I hope I have explained what he is needing well enough to get him an answer and point him in the right direction.

Thanks for your assistance.


Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[KenWright]

VLOOKUP will do that for him:-

Assuming data to be searched is on Sheet2 in the range A1:B26, with the value being looked up in Col A and the corresponding value required being in Col B

On Sheet1, assuming the value to search Sheet2 for is in A1, then in B1 put the following formula:-

=VLOOKUP(A1,Sheet2!A1:B26,2,0)

Regards
Ken.............

 

[EllieFant]

Thank you Ken, I will pass this information onto Frank. I am sure he will be excited to get this working.


Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net