Using vlookup and indirect functions together

[jdfch2]

Hi,

Please can I ask if this can be done?

I am wanting to vlookup some data from a cell (K3) firstly then if that is blank, vlookup on L2, then if that is empty to use an indirect function to use a dropdown list from a named range.

I can do the first 2 parts IFERROR(IF(K3<>"",VLOOKUP(K3,Categories!B:D,2,FALSE),IF('Data Sheet'!L3<>"",VLOOKUP('Data Sheet'!L3,Categories!B:D,2,FALSE),"")),"")

I don't know how to add the indirect function as the 3rd option..

Many thanks

Jason

 

[Sixthsense]

if that is empty to use an indirect function to use a dropdown list from a named range.

Please let us know the cell address of the dropdown input selection.

 

[jdfch2]

It is a named range "Country"

 

[Sixthsense]

=IFERROR(IF(K3<>"",VLOOKUP(K3,Categories!B:D,2,FALSE),IF('Data Sheet'!L3<>"",VLOOKUP('Data Sheet'!L3,Categories!B:D,2,FALSE),VLOOKUP(INDIRECT(Country),Categories!B:D,2,FALSE))),"")