Conditional return value
 

New problem from me:

Coloumn A contains 12 articlenumbers, in coloumn B I would like packaging
size to appear. I've tried using IF, but it's limited to only 7 conditions.
PS! I'm not familiar wilth VLOOKUP

Conditional return value
 

Just create a table with the 12 article numbers in one column and the
packaging size in the adjacent column, let's say M1:N12. Then use the
formula

=VLOOKUP(A2,$M$1:$N$12,2,False)

--
__________________________________
HTH

Bob

"Espen Rostad" wrote in message
...
New problem from me:

Coloumn A contains 12 articlenumbers, in coloumn B I would like packaging
size to appear. I've tried using IF, but it's limited to only 7
conditions.
PS! I'm not familiar wilth VLOOKUP

Conditional return value
 

Thank you so much Bob, that did it! I'm impressed that you understood what i
wnated from that poor discripion ;o)

Bob Phillips skrev: