I have far too many IF's..

[RichardM]

For a small project I'm trying to multiply numbers with their base multipliers. I have 38 different items, and the script compares the name of the current item with the list, and when it hits a match of names, moves over to the corresponding base number and uses the multiplier on it to work out the new number, thus placing it in the cell.
There are roughly 2500 lines of multipliers, so understandably I don't really want to go down them and do this one by one..

Thanks for your help in advance, and here is the rather long IF that I tried. It should work, but I get error 512, which either means too many IF's or too much typing, I don't know which.

[David]

Have you thought of using VLOOKUP() for example?

Enter [type] a value that you would want from the list in column G into A2. Then, in the cell where this formula is to appear put this:

=D3*VLOOKUP(A2;G1:H38;2;0)

David.

[RichardM]

Thanks David, that worked brilliantly. I had looked at VLOOKUP but wasn't sure what I was doing with the index, though now I know how to use it, so thanks for that too