Log In
Register
Home
New Member
November 21, 2020
Offline
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
Trusted Members
December 20, 2019
Offline
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))
New Member
November 21, 2020
Offline
Thanks very much for your advise with my question.
Garry
June 25, 2020
Offline
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
New Member
December 18, 2020
Offline
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
1 Guest(s)
