H
hcacote
Hi,
I have the following table which contain a description of an item and
its weight
A B
Hat 1 red x
Hat 1 blue x
Hat 2 pink y
Hat 3 grey z
Cap 1 blue w
I want to set the column B according to lookup:
C D
Hat 1
Hat 2
Hat 3
Cap 1
I am trying the following code to get it to work
IF(SEARCH("Hat 1";$A1);VLOOKUP("Hat 1";C1
4;2);if(SEARCH("Hat 2";....
This is a rather clumbsy way to do it specially because my table as a
large number of different items.
Does anyone have a suggestion on to perform this operation in a better
way?
Thank you, best regards
Hugo CaçOte
I have the following table which contain a description of an item and
its weight
A B
Hat 1 red x
Hat 1 blue x
Hat 2 pink y
Hat 3 grey z
Cap 1 blue w
I want to set the column B according to lookup:
C D
Hat 1
Hat 2
Hat 3
Cap 1
I am trying the following code to get it to work
IF(SEARCH("Hat 1";$A1);VLOOKUP("Hat 1";C1
4;2);if(SEARCH("Hat 2";....This is a rather clumbsy way to do it specially because my table as a
large number of different items.
Does anyone have a suggestion on to perform this operation in a better
way?
Thank you, best regards
Hugo CaçOte