
New Member

November 21, 2020

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




Trusted Members

December 20, 2019



June 25, 2020

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
1 Guest(s)
