vlookup multiple criteria

[tvanduzee]

Hello
I have a sheet that contains "bios version", "Model" and "ComputerNames" columns. (A3:C150).
I also have 2 columns (J3:K22) that contain the Model and latest bios versions.

The bios versions in the A column are the versions currently on the computer, and the bios version in the K column are the latest version for each of the models.

In the "F" Column, I'm trying to build a vlookup function that will:
1. Look for and match the model, then if the model matches, compare the bios version (in the "K" column) to the bios version in the "A" Column. If the versions don't match "Update" appears in that "F" cell (on the same row as the computer model being compared). If the values don't match, the cell is blank.

Any suggestions?

Thank You
Terry

 

[C Moore]

In F3,

=IF(INDEX(K_range,MATCH(C3,J_range,0))=A3,"Current","Update")

 

[tvanduzee]

Thank you so much for the reply:
It works like a charm