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

paddyg1233

New member
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
 
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 ("").

VLOOKUP Values from One Sheet to Another in Excel.png

Download the Excel File:
 

Attachments

  • VLOOKUP Values from One Sheet to Another in Excel.xlsx
    10.1 KB · Views: 1

Online statistics

Members online
0
Guests online
56
Total visitors
56

Forum statistics

Threads
337
Messages
1,470
Members
624
Latest member
duytoi
Top