Expanded Vlookup
Okay, I need a way to compare two cells in one workbook to two columns in
another workbook. When I find those two cells that match exactly then I need
to return a value in another column.
I figure it is some kind of an expanded Vlookup. This is what I've come up
with so far, but I can't figure out how to make it work.
=VLOOKUP(A1:B2,'[workbook]worksheet1'!$A$2:$E$1000,4,FALSE)
|