Formula VLook-UP in 2 columns at once.

[pro356]

Is it possible to do a VLook-up in 2 columns? No problem with 1 column but need to return a value from table array where columns B and C in one spreadsheet match identically to columns H & I in other spreadsheet.

 

[SkipVought]

Hi,

Concatenate the Lookup range.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[bluedragon2]

Or, use the SUMPRODUCT Formula: FAQ68-4725

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...