Worked like a charm (the first one was what I needed).....Thanks so much
Sean!!!!

"Sean Timmons" wrote:

Are you saying you want the related values in columns O, P and Q based on the
VLOOKUP or do you always want specifically cells O3,P3 and Q3.

if the first,
=IF($B3=0,"",VLOOKUP($A3,'sheet 2'!$B$2:$U$572,14,0)&VLOOKUP($A3,'sheet
2'!$B$2:$U$572,15,0)&VLOOKUP($A3,'sheet 2'!$B$2:$U$572,16,0))

if the 2nd
=IF($B3=0,"",VLOOKUP($A3,'sheet 2'!$B$2:$U$572,whatever column your return
value is in,0)&O3&P3&Q3)

If you want spaces, add &" "& in between.

"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,