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?

 

[JWJ3640]

I can't see column No and row number in either sheets...

Columns B, C and D
Rows go all the way to 860

 

[SanjayGMusafir]

Columns B, C and D
Rows go all the way to 860

Use the formula below on sheet 1 in Cell B2 assuming B1 would be the header row

=XLOOKUP(1,(Sheet2!B:B=$B2)*(Sheet2!C:C=$C2),Sheet2!D:D,"Not Found")

Try this and update

 

[JWJ3640]

I can't see column No and row number in either sheets...

Columns b, c, d

Rows to 500 ish

 

[SanjayGMusafir]

Use the formula below on sheet 1 in Cell B2 assuming B1 would be the header row

=XLOOKUP(1,(Sheet2!B:B=$B2)*(Sheet2!C:C=$C2),Sheet2!D:D,"Not Found")

Try this and update

Try this and update

 

[JWJ3640]

Working!!!!!

You are awesome.

You just saved me a lot of time

 

[SanjayGMusafir]

Working!!!!!

You are awesome.

You just saved me a lot of time

Good to know that

Thanks for your patience

 

[JWJ3640]

Whoops spoke to soon. Picked up the first one, every one thereafter is not found?

 

[JWJ3640]

Nevermind - there is a space in front of all these names