lookup

[frapey]

I need to insert a property reference No. in a list of properties by
comparing with a second worksheet containing the reference No's. i think i
will need to match the first 2 or 3 lines of the address to do this.

Ref No | Address1 | Address2 | Address3
?????? | 15 | The Street | Our Town

i would appreciate any help with this as i need to import into Access using
ref no as unique ID
Any ideas?

 

[CLR]

Concatenation should help here..........make a new column on the left of
your second worksheet table called "concat"..........then put =A1&B1&C1 in
it to give you "15The StreetOurTown".......then do Copy > PasteSpecial >
Values on the column.........then name the entire range "MyTableName" or
something appropriate by highlighting the range and doine Insert > Name >
Define, and finishing the menu............

then on Sheet 1 use =VLOOKUP(A1&B1&C1,MyTableName,5,false) and copy it
down......

Change the Cell designations to match your data and the "5" in the formula
to match the column where your "Property Reference Number" is.......


Vaya con Dios,
Chuck, CABGx3