if function help

S

scott

I want to perform a vlookup within an if function.

If there is a number in A:A, then i want to perform a vlookup. However, I do
not know exactly what number will be in A:A.

Is there a way that I could set up an if statement, so that if any number
was in A:A, it would be true? Then I would be able to perform a vlookup for
that given number.

Hope I was clear.

Thanks for your help!

Scott W
 
D

Dave F

One way would be:

=IF(COUNTIF(A1:A10)>0,VLOOKUP(Your criteria),"")

assuming the range in question is A1:A10.
 
T

tim m

=IF(ISNUMBER(A1),{Put your Vlookup part here},{put whatever you want to
happen if not a number here})
 
Top