=INDEX(E:E,MATCH(A2&C2,Z:Z,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Hari" wrote in message
oups.com...
Hi,

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.

Regards,
HP
India