Excel Table Help

[befriend_my]

Dear friends,

I want to create a Excel page,
in which
Sheet 1 s 'A' column contains Some number or name
& 'B' column contains its Rate.
Eg A1 = 101 or Jasmine
& B1 = 105.00

What I want is, 'In Sheet 2 of same work book', when I enter any number/name of 'A' column (of Sheet 1) in cell A1 - its rate (Sheet 1 s B1) comes automatically in B1.

Thanks in advance.
Hoping for help.

Regards

[Tony Valko]

See this...

http://contextures.com/xlFunctions02.html

[judgeh59]

Here a workbook that does what you want....

you will have to copy the formula down in the lookup worksheet