Match 2 cells to produce a third value

Hi,

I have 2 sheets of data one for data the second for input and calculations.


SHEET 1 (Data)
HEADINGS - FROM / NUMBER
A / 81
C / 99
E / 01

SHEET 2 (Input & Calculations)HEADINGS - FROM / TO / FROM val / TO val

I want to be able to stick "A" in Col1 (FROM) and the number 81 to automatically appear in Col3 (FROM Val)


I am unabel to use LOOKUP as my Pocket PC doesen't recognise it.. VLOOKUP and HLOOKUP are ok though, I just can't seem to get them to work for me

L.

=Vlookup(A1,Sheet1!$A$1:$B$100,2)

is the same as =Lookup(A1,Sheet1!$A$1:$B$100)

Both look up item in A1 within sorted list $A$1:$A$100 and return from B1:B100

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save