VLOOKUP with multiple nested IF statements

[sclasen0024]

I am having difficulties with creating a formula. AS will look at AP if AP=PRIME it will use table 1 B4:B8&C4:C8 it will then look at AJ4 to determine where that number falls within the table to determine the value to return in range f4:f8. If the value in AP=OFF it will use table 2 d4:d8&e4:e8. I am so lost!!

{mod note: img tag removed - bad html}

 

[Special-K99]

Image unreadable.

 

[Gerald Higgins]

I am so lost!!

I am also lost because you have expressed your request in a very confusing manner.

Please can you explain more clearly what you want to do ?

It sounds as if MAYBE you want to do this -
If AP1="PRIME", lookup the value in AJ4 within the range B4:C8.
If AP1="OFF", lookup the value in AJ4 within the range D4:E8.
I have no idea what role is played by the range F4:F8.

Comment - for this to work, the value in AJ4 must actually exist in the range B4:B8 and D4:D8.