IF & VLOOKUP

[Equaliser]

This is the formula that I am using which works very well. =IF(E2=0,"
",(VLOOKUP(E2,Worcester,2,FALSE))). I have a range named WORCESTER for
looking up the answer that I need.
This is fine if the text in cell E2 DOES =Worcester. BUT, cell E2 will
sometimes =Portsmouth so I just edit my formula, which is not ideal. How can
I extend the formula so that it uses a different lookup range depending on
what is in cell E2?
Does this make sense?

[GaryE]

If I understand your question. This should work:


=IF(E2="Worcester",(VLOOKUP(E2,Worcester,2,FALSE)),if(E2="Portsmouth",
VLOOKUP(E2,Portsmouth,2,FALSE)),"").

HTH,

Gary

Equaliser Wrote:
> This is the formula that I am using which works very well. =IF(E2=0,"
> ",(VLOOKUP(E2,Worcester,2,FALSE))). I have a range named WORCESTER
> for
> looking up the answer that I need.
> This is fine if the text in cell E2 DOES =Worcester. BUT, cell E2
> will
> sometimes =Portsmouth so I just edit my formula, which is not ideal.
> How can
> I extend the formula so that it uses a different lookup range depending
> on
> what is in cell E2?
> Does this make sense?


--
GaryE
Posted from - http://www.officehelp.in