vlookup w/ 3 colums

Hello,

I know how to do a vllokup. What I want to do is a vlookup w/ 3 colums.
I would like to match 3 coulms and collent the forth.

I would like to match col a,b & c on both sheets and output col d from EX1 to EX2.

is this possible?

thanks in advance for any assistance.

You can add a column, merge the lines into one cell as in the attachment and then search it based on that.

regards,
Avinash

Huh..look at that.
Thanks so much.