View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default More then 7 IF functions?

You can replace your formula with a much simpler VLOOKUP, and this will
allow you to have many more products. First of all set up a two-column
table somewhere (assume Y1 to Z30 on the same Sheet1). In column Y you
would enter '010, '015, '020, '030 etc down the column, and in column Z
you would have product A, product B, product C etc adjacent to the
codes.

Then your formula can be replaced with this one:

=VLOOKUP(C4,Y$1:Z$30,2,0)

This takes the value in C4 and sees if there is an exact match in the
first column of the table Y1:Z30 - if there is it then returns the
value which is in the second column of the table (this is the parameter
2 in the formula). If there is not an exact match the formula returns
the #N/A error.

Hope this helps.

Pete