Combining VLOOKUP and IF formula

[BobG616]

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:

=IF(D25=AH25, "Received","Not Received")

My end result is either "Received" or "Not Received"

Can these be combined into one formula?

Thanks.


Bob

 

[T. Valko]

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:

=IF(D25=AH25, "Received","Not Received")

My end result is either "Received" or "Not Received"

Can these be combined into one formula?

Thanks.


Bob

Is the lookup formula in cell AH25?

Maybe something like this...

=IF(COUNTIF('PO_RO_Receipts_Detail 1 '!S:S,D25),"Received","Not Received")

 

[BobG616]

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


Thanks.

 

[T. Valko]

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


Thanks.

You're welcome. Thanks for the feedback!

 

[Kele]

Hi,

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

Thanks

 

[T. Valko]

Hi,

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

Thanks

Good deal!