Nested VLOOKUP

[FranAgrippina]

Good morning everyone!

I have attached a sample of what I am trying to accomplish.

The goal is to have the user select the company, then the contact name. At this point, I would like the correct phone number and extension to upload (in column 'Phone' and 'Extension' respectively). The information is currently on the 'Data' tab. But eventually I will put the data in a separate workbook.

I have tried to do work with a vlookup formula, but I do not think this is the right way to go about it.

Does anyone have any suggestions?

Thank you,

Louise

[AlKey]

Enter formula in F2 copy down and across

Please Login or Register  to view this content.

[FranAgrippina]

Thank you for the quick response AlKey, but the phone numbers are not uploading correctly when I copy the formula through on the sample sheet. The numbers for Jim and Jeff at GHI company are incorrect.

[AlKey]

Try this

Please Login or Register  to view this content.

[JohnTopley]

In F2

=IFERROR(INDEX(Data!$A$2:$F$6,MATCH(1,(Company=$D2)*(Contact=$E2),0),MATCH(F$1,Data!$A$1:$F$1,0)),"")

Enter with Ctrl+Shift+Enter

Copy across and down

Extended range in data for "future" headings

[FranAgrippina]

Thank you JohnTopley...the array works beautifully!

Have a wonderful evening!

[FranAgrippina]

AlKey....your solution also works beautifully...for anyone reading this post....either solution would satisfy parameters set forth in my problem.