Using possibly If and Vlookup

  • Thread starter Thread starter Lainyb
  • Start date Start date
L

Lainyb

I have a spreadsheet where I want to first of all look up hours worked in
cell N2 (within this cell is the number 35.00 or the number 37.00).

I then want to use this cell to do a lookup bringing back one salary if N2
is 35 or another salary if N2 is 37.

In my main spreadsheet I have a spinal column point in cell J2.

I have created two lookup tables on another spreadsheet named salary35 and
salary 37. These tables show the spinal point in one column and the
appropriate salary in anoter column.

eg

salary35

1 11187
3 11534
5 11899
7 12246
9 12629

salary 37

1 11827
3 12193
5 12579
7 12945
9 13351

So in total what I want to do is look up N2 and if the hours are 35 and the
spinal column point in J2 is 5, I want a formula that will return a salary of
11899.

I would really appreciate some help with this as I have been tearing my hair
out for ages. Can do basic look-ups but can't seem to pull together this one
to produce a result from more than one option.

Thanks
 
See possible answers to your first post in Excel.misc, if those answers
didn't help reply to that particular thread with what didn't work.

--


Regards,


Peo Sjoblom
 
Lainyb -

You need a formula like this (substitue the <nn salayr range table> pices
with your actual data ranges:

-IF(N2=35,VLOOKUP(J2,<35 salary range table>,2,FALSE),VLOOKUP(J2,<37 salary
range table>,2,FALSE))
 
Back
Top