Hello
A colleague has set up this index table which should work simply.
F10 - F35 is the number of 'BOXES' to look up
G9-P9 is the area code to look up.
Essentially when you type in area code (F6) and box count (H6) we expect a price to be shown (J6).
At the moment, there is an error when you enter a box number over 10. I have left this in the example sheet attached - 5 for area code 13 for box count; we are expecting £322 (K22) but getting #N/A.
I'm suspecting we are using the wrong type of look-up formula?
I was not present when the formula was set up.
Replica attached (for data protection)
Please help
Thank you
Z
Bookmarks