# Combining VLOOKUP and IF formula

#### BobG616

##### New Member
I have two formulae in different cells that I would like to combine into one formula.

=IF(ISNA(VLOOKUP(D25,'PO_RO_Receipts_Detail 1 '!S:S,1,FALSE)),0,(VLOOKUP(D25,'PO_RO_Receipts_Detail 1 '!S:S,1,FALSE)))

and then in the other cell:

Can these be combined into one formula?

Thanks.

Bob

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### T. Valko

##### Well-known Member
I have two formulae in different cells that I would like to combine into one formula.

=IF(ISNA(VLOOKUP(D25,'PO_RO_Receipts_Detail 1 '!S:S,1,FALSE)),0,(VLOOKUP(D25,'PO_RO_Receipts_Detail 1 '!S:S,1,FALSE)))

and then in the other cell:

Can these be combined into one formula?

Thanks.

Bob
Is the lookup formula in cell AH25?

Maybe something like this...

#### BobG616

##### New Member
Yes- the lookup formula is in AH25 and the IF COUNTIF formula works great.

Thanks.

#### T. Valko

##### Well-known Member
Yes- the lookup formula is in AH25 and the IF COUNTIF formula works great.

Thanks.
You're welcome. Thanks for the feedback!

#### Kele

##### Board Regular
Hi,

this is great it worked for me as well and stopped me having to do a look up

Thanks

#### T. Valko

##### Well-known Member
Hi,

this is great it worked for me as well and stopped me having to do a look up

Thanks
Good deal!

Replies
6
Views
155
Replies
8
Views
164
Replies
10
Views
444
Replies
4
Views
110
Replies
7
Views
251

1,195,596
Messages
6,010,639
Members
441,558
Latest member
lambierules

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back