VLOOKUP from multiple table arrays

Hi All,

Apologies if I don't have my terminology wrong here, I have never done a VLOOKUP by myself

What I would like the VLOOKUP to do is, look up a persons name from the tables on another sheet and paste the phone number.

The formula works however, what I cant work out is, if the list isn't sorted alphabetically the value it pastes is the wrong value

IFERROR(VLOOKUP(B3 & C3,'Contact Details'!A$3:C$114,3),IFERROR(VLOOKUP(B3 & C3,'Contact Details'!I$3:K$34,3),VLOOKUP(B3 & C3,'Contact Details'!Q$3:S$36,3)))

Please note, I googled to get where I am at the moment. Is there something I am missing.

It's best to attach a sample (read the yellow banner at the top of the page). But probably you just need to add "FALSE" to the end of your VLOOKUP formulas. i.e.,

IFERROR(VLOOKUP(B3 & C3,'Contact Details'!A$3:C$114,3,FALSE),IFERROR(VLOOKUP(B3 & C3,'Contact Details'!I$3:K$34,3,FALSE),VLOOKUP(B3 & C3,'Contact Details'!Q$3:S$36,3,FALSE)))

Thank you for the time to reply.

If I add FALSE, it returns #N/A

I will remove the sensitive data and post an example

Sample attached

Back to the drawing board, tried adding names from different lists and it always displays the wrong phone number

In Cell D3, try this formulas

Please Login or Register  to view this content.

Originally Posted by Gregb11

In Cell D3, try this formulas

Please Login or Register  to view this content.

Wow. Ok.. That is amazing. Thank you.

You're welcome. Glad it worked and thanks for the rep!