Forum Discussion
Solved
LEFT formula based on adjacent cell text and pertaining value
Hi,
i have a report which consists of thousands of entries in column A and B only (column C and D do not exist in the report).
The example below shows all the categories in Column B within th...
Dan,
I've understood from your explanation that you want to extract from column A a text with a set of characters based on a category:
- 6 characters with the categories: 100 Jeans, 105 Jeans Kids, 110 Pants.
- 10 characters with the others.
If so, you don't have to create a helper column (column c), you can identify the set of characters inside the formula in cell D2 as follows:
=LEFT(A2,IF(OR(B2="100 Jeans",B2="105 Jeans Kids",B2="110 Pants"),6,10))
Hope that helps.
Hi Dan,
You'll need a formula like =LEFT(A2,C2). But if you don't want to use column C, where are the numbers 6 and 10 based upon?
You could use =LEFT(A2,IF(B2="100 Jeans",6,10)), but then you'll need a long formula if you want to include all criteria.
And why not just hide column C?
Kr
TK
Hi Tinn,
Column C was simply added/used as a reference for my query here, it doesn't exist in the report i pull therefore cannot be hidden.
thanks,
Dan