Vlookup - Multiple Columns matching

Hi Everyone:

I'm pretty new to excel and have an issue trying to identify data across 4 columns. I have to sets of data set up as

ID Number Name ID Number Name

Columns A&B have 17,500 rows and columns C&D have 6,200 rows.

I'm trying to run vlookup to identify ID numbers in Column A that match ID numbers in Column C, with result appearing in Column E.

If anyone can help I'd really appreciate it. I've been working on this for hours and to be honest am totally lost at this point.

Thank You

Where is the multiple columns match? what is the result for column E?

Bob Phillips said:

Where is the multiple columns match? what is the result for column E?

Click to expand...

Sorry maybe I got it wrong - I'm trying to match the ID number from Column A with the ID number in Column C and have the result (Column A value) appear in Column E

Try this

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(ISNUMBER(MATCH(A2,$C:$C,0)),A2,"")[/FONT]