| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
