[Solved] VLOOKUP from another Sheet Based on Multiple Condition in Excel

[paddyg1233]

Hi i have a table of values, as example

Headers
ID Name Age Occupation Reg Date
1 Bob 30 Cleaner 01/01/2024
2 Edd 28 receiptionist 01/10/2023

In a new sheet i have another table with

ID Occupation
1 Cleaner

I want to add a column to this second table that would Vlookup the ID in the other sheet and look up the occupation in the other sheet and if both values match then bring back the Reg date against that ID and Occupation.

Result
ID Occupation Reg Date returned from other table
1 Cleaner 01/01/2024

 

[shamimarita]

Hi i have a table of values, as example

Headers
ID Name Age Occupation Reg Date
1 Bob 30 Cleaner 01/01/2024
2 Edd 28 receiptionist 01/10/2023

In a new sheet i have another table with

ID Occupation
1 Cleaner

I want to add a column to this second table that would Vlookup the ID in the other sheet and look up the occupation in the other sheet and if both values match then bring back the Reg date against that ID and Occupation.

Result
ID Occupation Reg Date returned from other table
1 Cleaner 01/01/2024

Hello Paddyg1233,

To get the Reg Date based on the ID and Occupation, I used the following formula:

Here, I used VLOOUKP and IF functions to get the expected value.

=IF(VLOOKUP(A2, Sheet1!$A$2:$E$4, 4, FALSE) = B2, VLOOKUP(A2, Sheet1!$A$2:$E$4, 5, FALSE), "")

This formula checks if the Occupation in Sheet2 matches the Occupation returned by the VLOOKUP. If they match, it returns the Reg Date, otherwise, it returns an empty string ("").



Download the Excel File: