what if formula problem (excel 2000)

Topic

New Reply

What is problem with this “IF” formula. What must I do to check a range for a name and then report the results of another cell?

Thanks for the help

Reply | Quote

Replies

Personally I’d use the VLOOKUP function on this.

=VLOOKUP(A5,A5:E8,5) entered in G5.

Reply | Quote

Thanks Preston,

That is a better way to go.
Appreciate the help

Reply | Quote

Hello Preston,

I just gave this a try with the Vlookup after I said it seemed like a better way to go. I entered the formula in cell G5 as suggested and got the result from one cell below the desired. Where might this be in error?

Thanks again for the assist

Reply | Quote

Preston accidentally forgot the last argument. it should be

=VLOOKUP(A5,A5:E8,5,FALSE)

FALSE means that you don’t want an approximate match, but an exact one.

Reply | Quote

Thanks!

Reply | Quote

this is a GREAT board.

Thanks again all
cvbs

Reply | Quote