Hi, can anybody help me with this formula that i can't work out please?
i have a drop down box in one column with 5 different sizes ie Extra Small, Small, Medium, Large and Extra Large and next to that l would like a number value to appear when a certain drop down is selected.
Ie
Extra Small would equal 32
Medium would equal 56
Extra Large equal 100
Any help with this would be great as l can't figure this out.
Thanks in advance
Garry
It is so much easier if you add workbook examples instead of pictures
you should be able to use an index/match or vlookup
=INDEX(P1:P5,MATCH(A2,O1:O5,0))
Thanks very much for your advise with my question.
Garry
Hi Garry,
If you're on 365, then you can use XLOOKUP (formula for cell H3 in your pictured example) :
=XLOOKUP(G3,$B$45:$B$49,$C$45:$C$49)
(the dollar signs mean that the formula will always look in those rows and not increment when the formula is copied down to the rest of your data)
jim
Try this formula
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).
Regards,
Rick Bale
