if function help
 

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

if function help
 

One way would be:

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

assuming the range in question is A1:A10.

"scott" wrote:

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

if function help
 

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

"scott" wrote:

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

if function help
 

Great! Thanks so much for the quick response!

Cheers!

"scott" wrote:

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