| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Vlookup and If functions simultaneously
Is it possible to use Vlookup and If functions together in one formula? If
so, please give an example. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup and If functions simultaneously
Depends on the If you want!
If(I3="",VLOOKUP(J2,Sheet1!A:E,4,0),0) Are you attempting to accomplish something that we can help with? "Vlookup and If" wrote: Is it possible to use Vlookup and If functions together in one formula? If so, please give an example. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup and If functions simultaneously
Is it possible to do the vlookup first and then based on what is in the cell
apply the if function? "Sean Timmons" wrote: Depends on the If you want! If(I3="",VLOOKUP(J2,Sheet1!A:E,4,0),0) Are you attempting to accomplish something that we can help with? "Vlookup and If" wrote: Is it possible to use Vlookup and If functions together in one formula? If so, please give an example. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup and If functions simultaneously
Well, that would be =IF(VLOOKUP(J2,Sheet1!A:E,4,0)="X","TRUE","FALSE")
"Vlookup and If" wrote: Is it possible to do the vlookup first and then based on what is in the cell apply the if function? "Sean Timmons" wrote: Depends on the If you want! If(I3="",VLOOKUP(J2,Sheet1!A:E,4,0),0) Are you attempting to accomplish something that we can help with? "Vlookup and If" wrote: Is it possible to use Vlookup and If functions together in one formula? If so, please give an example. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| $ for VLOOKUP functions | Excel Worksheet Functions | |||
| VLookup Functions | Excel Worksheet Functions | |||
| if and vlookup functions | New Users to Excel | |||
| Using VLOOKUP, IF and RIGHT functions together | Excel Worksheet Functions | |||
| vlookup and hlookup simultaneously | Excel Worksheet Functions | |||
Linear Mode
