Forum Discussion
HelpandImproveAP
Mar 23, 2022Copper Contributor
Require assistance on an IF formula please
Hi, Really hoping someone can help with my query -- I am looking to use a formula that is using one cell (A1) as data but cell A1 has a dropdown list with numerous other options... say Test 1, Te...
HelpandImproveAP
Mar 23, 2022Copper Contributor
Hi,
Thanks so much for your swift response.
I've tried both but unfortunately it's not working...
Can you breakdown what those formulas do please as I'm a bit confused as to the second formula? If I know this I could think of a workaround
Thanks so much for your swift response.
I've tried both but unfortunately it's not working...
Can you breakdown what those formulas do please as I'm a bit confused as to the second formula? If I know this I could think of a workaround
HansVogelaar
Mar 23, 2022MVP
Here is a picture. The formula =VLOOKUP(A1, List, 2, FALSE) takes the value of cell A1 (Test 12 in the screenshot), and looks it up in the first column of the List range. It then returns the corresponding value from the 2nd column of the List range. The 4th argument FALSE tells Excel to look for an exact match.