E
Equaliser
If I enter York in cell E2 I want Vlookup to be
=VLOOKUP(E2,York,2).
But if I enter Hereford in cell E2 the Vlookup formula must be
=VLOOKUP(E2,Hereford,2).
So, I need this part of the formula to change depending on what is in cell
E2. If there were only two variations I would use a nested formula? But I
have around 25 possibilities that I need to look up. Is there an easier way?
=VLOOKUP(E2,York,2).
But if I enter Hereford in cell E2 the Vlookup formula must be
=VLOOKUP(E2,Hereford,2).
So, I need this part of the formula to change depending on what is in cell
E2. If there were only two variations I would use a nested formula? But I
have around 25 possibilities that I need to look up. Is there an easier way?