lookup tables

Posted by Shabina on February 07, 2002 2:18 AM

I would like to know how can I lookup address on excel sheet from another sheet. Reason being for this I have to input address on invoices manually but the help menu on excel does not show you step by step methout on how to lookup names and address from on excel sheet to another excel sheet.

Please help
Regards
Shabina

Posted by Yogi Anand on February 08, 2002 9:30 AM

Posted by Yogi Anand on February 08, 2002 9:36 AM

Hi Shabina:
If you are going to use the VLookup function, then for the range to be looked at precede it with the worksheetname & ! -- e.g. if your lookup value is in sheet 1 in cell A1, your lookup_range is in sheet2 k1:Z101, and the value you are looking for is in column 2, and you want an exact match for the info -- then enter the following in the cell of interest:

=VLOOKUP(A1,sheet2!$K$1:$Z$101,2,false)

HTH

Yogi Anand
ANAND Enterprises (broken link)