Can vlookup compare 2 columns instead of 1?

[Mr. DMSMS]

Can a conditional vlookup or other commands be created that compare and match two columns, A and B, in Tabs 1 and 2 within the same File, before copying the content of a cell from Tab 2 into Tab 1?

I’m using Excel 2007 with Windows XP.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I placed 2 downloaded reports from a CAD database into Tabs 1 and 2 of my Excel file. I’m trying to add all of the manufacturer’s part number in Tab 2 to the correct rows of Tab 1. Any suggestions?

(Unfortunately, my CAD reports don't provide a combined list. Column B categories are generic and are used with many parts. The CAD part file in Column A can document several part number variations, indicated by the small x.)
<o></o>

Tab 1 –
Column A _ _ _ _ _ _ _ _ _ _Column B _ _ _ _ Column C
D38999_26xD15Px.sldprt _ Conn, Circ, Plug _ CONN, CIRC, PLUG,..., 175 DEG
<o>D38999_26xD15Px.sldprt _ Conn, Circ, Plug _ CONN, CIRC, PLUG,..., 200 DEG</o>
<o></o>

Tab 2 –
Column A _ _ _ _ _ _ _ _ _ _ Column B _ _ _ _ _ Column C
D38999_26xD15Px.sldprt _ _Conn, Circ, Plug _ _D38999/26WD15P
D38999_26xD15Px.sldprt _ _Conn, Circ, Plug _ _D38999/26FD15P

 

[Derek Brown]

If I understand the problem correctly, the answer is "yes, with a helper column".
In the formula:
=VLOOKUP(A1&B1,'TAB 2'!$A$1:$D$2,4,FALSE)
column A on TAB 2 would be the helper column with the formula:
=B1&C1
so the VLOOKUP would be able to match the concatenated value in the first argument with the value in the 'helper' column (you can of course hide that column).

 

[number kruncher]

Or, use the INDEX and MATCH commands.