Hi all,
I'm currently trying to set up a spreadsheet to help me in my cake business.
My query is, if I select an option from a drop-down list (say 6 cakes) in cell P5, I need it to pull the information from cell T1 and display it in cell Q5.
Like wise, if I select 12 cakes in cell P5, it needs to pull the info from cell T2 and display it in cell Q5. This is so on for however many batches of cakes I need.
excel screenshot.jpg
I tried using an IF function but I don't really have a FALSE test value.
Can what I am asking be done?
Any help would be very much appreciated
Many thanks
Kate
Bookmarks