IF VLOOKUP & CONCATENATE
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,
|