You want something like:

=if(isnumber(a1),vlookup(a1,Sheet2!A:B,2,true),vlo okup(a1,Sheet2!C:D,2,false))

--
Regards,
Fred


"Angie" wrote in message
...
Dave,
I've also been completely stuck with a coversion chart and am not sure what
type of "IF" or "LOOKUP" might solve my problem.

I need to have a valur replace a grade entered. However, that grade may
either be numberical or not. For example:

if grade is entered as 94 the it shoukld be replace as 4.0, if it's entered
as A it should be replaced with 4.0.

Can you offer a suggestion?

"Dave F" wrote:

Yeah, you can do that:

=IF(B1<5,C1,IF(AND(b54,B5<11),D1,E1)

Dave
--
Brevity is the soul of wit.


"RS" wrote:

Will Excel allow you to do an if/then statement which evaluates a value and
applies a different equation depending on what that value is?

i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100)

or simpler ... If B1<5, then C1

or If B1=the numbers 5-10, then D1(formula)

If B110, then E1(formula)

Any help would be much appreciated!! Thanks!!!