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.
Bookmarks