Microsoft Excel Look Ups

Closed
Excel_Novice - Feb 3, 2011 at 08:47 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 8, 2011 at 04:14 PM
Hi Guys,

Please can you help.

I am trying to do a formula which allows me to look take a cell, for example the word 'help' and look for it in a separate worksheet. Then to take tha value in the column next to the word.

Work book 1
A1
= search for the word help in work book 2 and returns £10.00

A2
= search for the word car and for the cell to equal £15.00

etc


A b
1 help £10.00
2 car £15.00
3 bus £20.00


Any help would be greatly appreciated

Thank you

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 8, 2011 at 04:14 PM
Is it two different workbook or sheets?
0