Lookup for concatenated data

Giganews Newsgroups
Subject: Lookup for concatenated data
Posted by:  Hari (excel_ha…@yahoo.com)
Date: 20 May 2006


Probably I have asked this before, but I might have missed it.

I have raw/source data in Column A and C (together A and C constitute
Unique ID) of sheet1 extending up to 1000 columns.

I also have some data in column Z (unique ID) and this data maps to
combination of data in A and C.

Presently in order to do a vlookup of Z with A2&C2, I have to create a
helper column D in which D2 = A2&D2 and use this helper column as the
TABLE ARRAY. Is there a way in wich we could perfom a lookup of Col Z
with A and C (and return value in Column E), without creating a helper
column. Probably some array formula could do this.

Please guide me for the same.