I wanted to know if anyone could help me.

I have a spreadsheet and want to do some lookups.

I need the formula to look at a cell in main spreadsheet and if the cell is
35 return the 1st lookup and if the cell is 37 then return the second lookup
(c2,salary,3,false) or (c2,salary,4,false) basically I am trying get
spreadsheet to bring in one salary if the person works 35hrs and a different
salary if the person works 37 hours.

Any help would be grateful - I have been struggling with this for ages.

Thanks