Pull data from another tab based on value in drop down menu

[RodneyC]

I have a drop down menu in cell C7 where users can select a value from about 40 different options. This part works perfectly.

In cell C9 I need a formula that will look in a tab named Source in rows A665 – A753 for the value in C7. If it finds the C7 value, display the corresponding value from Source in column B.

Thanks in advance

 

[Fluff]

How about

=XLOOKUP(C7,source!A655:A753,source!B655:B753,"",0)

 

[RodneyC]

How about

=XLOOKUP(C7,source!A655:A753,source!B655:B753,"",0)

Thanks for the quick reply. That produces a #NAME? error

 

[Fluff]

Are you using xl365 as per your profile?

 

[RodneyC]

Microsoft® Excel® 2016 MSO (Version 2111 Build 16.0.14701.20254) 64-bit I may need to update my profile

 

[RodneyC]

I got it to work using this: =IFNA(VLOOKUP($C$7,source!A665:C753,2,FALSE),"") Thanks for the help.

 

[Fluff]

I may need to update my profile

Agreed.

Glad you sorted it & thanks for the feedback.