vlookup formular

[xiaojo]

=VLOOKUP (A2, Data, MATCH(A1, Row 1, 0))

how to use this formular if i am processing date from different worksheet?
cuz i have named a particular data area as Jan for example.. in the table_array criteria.. how do i specify the data area to refer?

 

[Aladin Akyurek]

A different worksheet or workbook?

 

[xiaojo]

different worksheet..

 

[Aladin Akyurek]

different worksheet..

Let D1:F60 in Sheet2 house the lookup table including the labels/headers. Labels are in D1:F1.

Select D2:F60 and name the selection LTable via the Name Box.
Select D1:F1 and name the selection LFields via the Name Box.

Given the names just defined, you can set up a VLOOKUP formula like this...

=VLOOKUP(lookup-value,LTable,MATCH(field-value,LFields,0),X)

where X is 0 (FALSE) or 1 (TRUE).

 

[Excel=Junky]

You need to remember that the VLOOKUP formula if numbers of any kind are used they MUST be in ascending order so if your data area is not in ascending order when you formulate you will get a NA# value or #### value. I had a similar problem and I used INDEX and MATCH together

 

[Aladin Akyurek]

You need to remember that the VLOOKUP formula if numbers of any kind are used they MUST be in ascending order so if your data area is not in ascending order when you formulate you will get a NA# value or #### value. I had a similar problem and I used INDEX and MATCH together

Re-read the Help file.