Ntema, excelledsoftware was asking whether you could attach the workbook itself, not paste in a copy of some of the text. As you can see from looking at the result yourself, what happens when you paste it like that is no help.

However, I can tell you part of what your formula is doing. For the following description let's assume that your formula is in a worksheet named Here; if so, the formula is taking the value in Here!A13 (relative) and looking it up in bench!$C$6:$F$1706. It's assuming that that lookup table is sorted in ascending order; I think if any of the values in col C are out of order, it stops looking at that point. It also stops if it finds a value that is greater than Here!A13, and returns the one just before that, even if it isn't an exact match.

The column it's to pull the data from depends on the contents of row 1 and 2 in Here col C. If the value in $C$1 is one of the 12 Rock Groups, the VLOOKUP pulls the lookup value from bench col D. If what's in Here!$C$! isn't a valid Rock Group, then it checks the value in $C$2, and if it's one of the grade groups then VLOOKUP pulls the lookup value from bench col E. If what's in $C$2 isn't a grade group, either, then VLOOKUP returns the contents of bench col C, in other words the value it found to be a match.

---

Since every row on Here is looking up the same values in $C$1 and $C$2—unless that's a mistake on your part, but I don't suppose it is—allow me to suggest something simpler: Calculate the correct column at the top of the worksheet, and use it for every VLOOKUP in the rest of the sheet. Something like this: In $C$3 putIf you like, you can simplify it a bit without the NOTs:Now make your VLOOKUP just use the column value that you calculated the one time:That is, unless you now see that you're using the wrong columns, or the wrong VLOOKUP range_lookup mode, or something.