Try this

=IF(AND(B3<0,NOT(ISNA(LOOKUP(A3,Sheet2!B2:B572))) ),Sheet2!O3&Sheet2!O3&Sheet2!Q3,"")

Mike

"sueshe" wrote:

Thanks!!! I tried your formula Mike, but am not getting anything now.

"Mike H" wrote:

Tasha,

Try this

=IF(AND(B3<"",NOT(ISNA(LOOKUP(A3,Sheet2!B2:B572)) )),Sheet2!O3&Sheet2!O3&Sheet2!Q3,"")

Mike

"Tasha" wrote:

Can someone help me please? Need to know, how would I put into a formula, if
$B3=0, then leave cell blank, otherwise, look-up cell A3 on sheet 2 from
B2:B572, and if a match is found, concatenate from sheet 2 cells O3, P3 and
Q3.

This is the formula I have as far as I could go with it, but didn't know how
to get the concatenate part in there

=IF($B3=0,"",VLOOKUP($A3,'sheet 2'!$B$2:$U$572,