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



"bchappell" wrote:

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?

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

On Feb 6, 3:42*pm, bchappell
wrote:
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?

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.

"CLR" wrote:

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



"bchappell" wrote:

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?