Index Match Formulas

jonnie_rc · #1 08-31-2017, 05:49 PM

Hi,

I have a problem with picking up rates. I have an average rate and i need to pull from a table the closest fixed rate to the average. I have a jobcode reference i need to use as well as a step. I have attached a sample of the problem. I however have got hundreds of lines of this with many different rates and codes etc.

I ahve tried to use INDEX(MATCH.......formula but i cannot seem to get it to work.

Any help would be welcomed.

Thanks in advance,
john

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Index and Match functions	aman.chauhan	Excel	1	06-18-2016 02:09 AM
Index match vba	grexcelman	Excel	0	03-05-2015 10:55 PM
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM
Vlookup and If conditions together along with match formulas	david_benjamin	Excel	2	04-11-2011 11:30 AM