Vlookup Multiple Criteria

[JWJ3640]

Hello, I am trying to vlookup based on multiple criteria. Last name, first name, then looks up address on sheet 2.

Any thoughts?

 

[SanjayGMusafir]

View attachment 72856

Hello, I am trying to vlookup based on multiple criteria. Last name, first name, then looks up address on sheet 2.

Any thoughts?

Can you update your Current Excel Version & Platform here as well as in your Profile. The solution will depend on that.

 

[JWJ3640]

Verzion 16.4

 

[JWJ3640]

I am not sure on platform

 

[SanjayGMusafir]

Verzion 16.4

Excel Version? 2016, 2019, 2021 ????

 

[SanjayGMusafir]

I am not sure on platform

Are you using Mac OS or Windows?

 

[JWJ3640]

2022 Mircosoft 365 I think

 

[JWJ3640]

mac

Are you using Mac OS or Windows?

mac

 

[SanjayGMusafir]

2022 Mircosoft 365 I think

Then XLOOKUP is the best bet

Assuming Last name is in column B, First Name is in Column C, And you want to look up for Values in Column D

=XLOOKUP(1,(B:B="Last Name Cell address here")*(C:C="First Name Cell address here"),D:D)

Remember to change cell references according to your file.

 

[JWJ3640]

Do you mean "Last Name", "First Name" and "Address"?