IFERROR, VLOOKUP and OFFSET

[abbeyb]

Hi There!

I am trying to create a formula, whereby I am looking at the next cell and using vlookup on 23 tables to find that value, then increase by one

for example in relation to pay scales
TABLE ONE
1a - 10,000
2a - 20,000

TABLE TWO
1b - 15,000
2b - 25,000

Person is on 1b - I want the formula to read in cell A1 they are on 1b, find it in the pay tables, and increase automatically to the next scale until at the top.

The current formula I have is

=IFERROR(VLOOKUP(A1,Table1,2,FALSE)+OFFSER(A1,-1,0)........IF ERROR(VLOOKUP(A1,Table23,2,FALSE)+OFFSET(A!,-1,0), "N/A"

It currently uses a lot of memory sending my computer in a spin and all results are N/A. Does anyone have a more effective solution?

 

[braindiesel]

I am trying to get there but I am a bit confused with your wording.

You have IFERROR - N/A... and then you have a VLOOKUP for a different value on each chart... I cannot find 1A on Table 2 so... N/A
also...
This reference (OFFSET is misspelled)
OFFSER(A1,-1,0) and there is NO row that is -1 rows to cell A1, so that will produce an error as well

Let's start there