I'm trying to learn some new formulas & have come across SWITCH.
I know how to use VLOOKUPS
I have a list of names of Fruit in Column A - in A1:A5 & a list of costs for each next to them in B1:B5
In D1 I want to type some fruit e.g. Apple, which is also in A3, the press Enter when I have...