couldn't you concatenate the 2 values in a helper column and then search for
that?

--


Gary


"Harish Mohanbabu" wrote in message
...
Hi,

There are two excel sheets which contain the following two main columns -

---------------------------------------------------
Order No (Column E3) | Item No (Column F3)
---------------------------------------------------

I have to compare records across both sheets and find out those records
that
match on both conditions.

If I have to match single column, then I would have used VLOOKUP function.
But it looks like VLOOKUP doesn't work if I try to match two columns -
i.e.,

If I write like -
=VLOOKUP(E3,'Sheet2'!A4:B430,1,FALSE) - this works

But if I write -
=VLOOKUP(E3:F3,'Sheet2'!A4:B430,1,FALSE) - this doesn't seem to work

So my question is - is there any functionality in Excel that I can use for
matching 2 or more columns? Or is there any other alternative?

Can some one let me know please.

Thanks in advance,

Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/