Lookup help needed...

[Sleeplol]

Hello,

The formula in my calculator answer cell is =F10/LOOKUP(F10,Sheet1!$B$3:Sheet1!$B$1000,Sheet1!$C$3:Sheet1!$C$1000)+F5
But I would like to reference a different "Lookup" depending on the value in F4
If F4 is below 15 I would like to reference columns B & C (as in the current formula above)
If F4 is above 15 I would like to reference columns K & J

I would appreciate any help with this.
Thanks

 

[jasonb75]

K & J, or J & K?

=IF(F4<15,F10/LOOKUP(F10,Sheet1!$B$3:Sheet1!$B$1000,Sheet1!$C$3:Sheet1!$C$1000)+F5,F10/LOOKUP(F10,Sheet1!$K$3:Sheet1!$K$1000,Sheet1!$J$3:Sheet1!$J$1000)+F5)

 

[Sleeplol]

Hi Jasonb75,
Yes, J then K
Good Catch!

This formula works perfectly (after switching J & K lol)

Many thanks