ExcelBanter - Using Vlookup and If functions simultaneously

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using Vlookup and If functions simultaneously (https://www.excelbanter.com/excel-worksheet-functions/205276-using-vlookup-if-functions-simultaneously.html)

Vlookup and If

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.

Sean Timmons

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.

Vlookup and If[_2_]

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.

Sean Timmons

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.

All times are GMT +1. The time now is 06:25 PM.