Finding errors or not.....

  • Thread starter Thread starter bchappell
  • Start date Start date
B

bchappell

I have 3 columns that are checking item sku designations and determining if
the come in different materials. I need a 4th column to return which material
it comes in...

1 2 3 4
LAM VINYL PLASTIC AVAILABILITY
TKC-LAM #N/A #N/A ?

How can I get this to work?
 
Change your lookup formulas in the three columns to be qrapped in an IF
statement like this....

=IF(ISNA(YourFormula),"",YourFormula).....this will return a null (nothing)
if the item is not found, rather than #N/A

Then in your Availability column, you could use

=A2 &" "&B2&" "&C2

Vaya con Dios,
Chuck, CABGx3
 
One way:

=IF(ISNA(A2),"",A1)&IF(ISNA(B2),"",B1)&IF(ISNA(C2),"",C1)

Alternatively, intercept the error returned from the formula in A2,
B2 and C2 using ISNA, and return "" instead, then your formula could
be:

=IF(A2="","",A1)&IF(B2="","",B1)&IF(C2="","",C1)

Hope this helps.

Pete
 
I tried both solutions and found them to work equally well.

I never would have thought of using Concatenation in this fashion.

Thank you very much gentlemen.
 
Back
Top