Excel Data Validation List - Combine Static Value and Formula

[neb255]

Hello,
I am looking for a way to create a data validation dropdown list in cell G17 which combines a static value of "GBP" and a formula. The formula is a vlookup which returns a local currency, and my end goal is to provide the option to select either the result of the vlookup or GBP in the dropdown.

I have tried using the below in the Data Validation List Source but none seem to work:
=OR($C$5,"GBP") where C5 is a cell containing the vlookup
=[$C$5,"GBP"]
={$C$5,"GBP"}
[$C$5,"GBP"]
{$C$5,"GBP"}
GBP,=VLOOKUP($F$17,$C$16:$D$24,2,FALSE)
GBP,VLOOKUP($F$17,$C$16:$D$24,2,FALSE)
=VLOOKUP($F$17,$C$16:$D$24,2,FALSE),GBP
=VLOOKUP($F$17,$C$16:$D$24,2,FALSE),"GBP"
=(VLOOKUP($F$17,$C$16:$D$24,2,FALSE)),"GBP"

Using just the vlookup in the data validation source works fine, however i cannot seem to figure out how to combine the result with "GBP" as a second option.

Thanks

 

[Saba Sabaratnam]

You could create a drop down list using Vlook to look up other currencies and plus GBP as shown below.

Then refer the drop down list in your data validation box as source.

Kind regards

Saba

 

[neb255]

You could create a drop down list using Vlook to look up other currencies and plus GBP as shown below.

Then refer the drop down list in your data validation box as source.

View attachment 41387

Kind regards

Saba

Hi Saba,
Thanks for the suggestion. I had thought about this, but was hoping for something which could be built directly into the data validation source rather than creating a separate lookup reference.