Comments on: How to Use VLOOKUP with Multiple Criteria

By: jmarkus

jmarkus — Mon, 03 Jun 2024 18:56:58 +0000

In reply to Ariyo. Yes! Create a helper column in both tables that concatenates the four criteria columns, then use VLOOKUP with the composite key to find and return the desired value. For example, concatenate columns A, B, C, and D in Table 1 with =A2 & "|" & B2 & "|" & C2 & "|" & D2, and in Table 2 with =G2 & "|" & H2 & "|" & I2 & "|" & J2, then use =VLOOKUP(L2, $G$2:$F$100, 6, FALSE) to retrieve the value.

By: Christopher Daniel

Christopher Daniel — Wed, 14 Dec 2022 03:21:25 +0000

In reply to Amber. Nice catch Amber, thanks!

By: Ariyo

Ariyo — Mon, 19 Sep 2022 07:13:36 +0000

Thank you Sumit for the article.

I have 2 tables, I want to compare 4 similar columns in both tables then return the value in a fifth column using vlookup.

Is this possible?

By: Amber

Amber — Mon, 14 Jun 2021 17:51:11 +0000

I think this has a few typos:
To display the hourly rate of, say, Employee ID “E010”, you need to retrieve it from the Employee table using the VLOOKUP function. This is what you will enter in cell E3:

=VLOOKUP(A3,$A$3:$C$8,3,false)

And should instead say:

To display the hourly rate of, say, Employee ID “E010”, you need to retrieve it from the Employee table using the VLOOKUP function. This is what you will enter in cell **F3:

=VLOOKUP(E3,$A$3:$C$8,3,false)