Forum Discussion
JD2170
Jul 24, 2023Copper Contributor
How to combine IF OR functions
So I want to do the following:
1 cel has a dropdown of 3 items
in another cell I want to say:
if option A then 1 comes out
if option B then 2 comes out
if option 3 then 3 comes out
How do I fix this please. Thanks
- PeterBartholomew1Silver Contributor
A newer function that replaced MATCH in 365:
= XMATCH(selected, validationList)
The 'exact match' is now the default. The defined names can be chosen according to the context.
- JD2170Copper Contributor
My source of the dropdown is in another worksheet same workbook
Worksheet A:2MER010101Kwalitatiefgroenversterkthetdistrict 5074000000 2MER010102Sliminvestereninhetopenbaardomein 5072500000 2MER010103Sportenspelzijngeïntegreerdinhetopenbaardomein 5071000000 This I want to combine in worksheet B
Doelstelling Bpl Where "doelstelling has the dropdown of the first colums (2MER....) and the Bpl has then the option which is 1:1 (so if they choose 2MER010101 then the option "5074000000" comes out; so on)
I've tried your solutions but they daon't work for me. Thanks for the info
Let's say the source is B2:B4 on a sheet named Source Data.
The formula from my previous example then becomes
=MATCH(A2,'Source Data'!$B$2:$B$4,0)