Try this:

=VLOOKUP(J2,INDIRECT("Salary"&N2),2)

Hope this helps.

Pete

On Nov 6, 9:44*am, Lainyb wrote:
I was wondering if anyone can help me create a look-up as I am tearing my
hair out trying to get it to work.

In main spreadsheet I have a cell N2 with 35.00 hrs or 37.00 hrs.

I want to use look at this cell and then use this cell to decide what lookup
should be used to achieve result.

I then use cell J2 (spinal column point) and look up defined lookup on
another spreadsheet to get the appropriate salary for 35hrs or 37hrs

My defined lookups a

salary35

SCP * * *Salary
* 1 * * * *11187
* 3 * * * *11534
* 5 * * * *11899
* 7 * * * *12246
* 9 * * * *12629
*11 * * * 12976
*13 * * * 13395 etc

and

salary37

SCP * * *Salary
* 1 * * * *11827
* 3 * * * *12193
* 5 * * * *12579
* 7 * * * *12945
* 9 * * * *13351
*11 * * * 13717
*13 * * * 14161 etc

To summarise - I am trying to look up the number of hours a person works
(N2) and then use the spinal column point (J2) to lookup and produce in my
new cell the appropriate salary using the lookup tables - salary35 or
salary37.

Thanks

--
Lainyb