Match formula syntax

**Traymond** · 01-10-2011, 11:53 PM

I have a match formula that i can't seem to get entered correctly. i am converting this from a lotus spreadsheet to an Excel spreadsheet. I attached a file so you can see the formula in action. i should be getting 14.2 in cell B3.

If someone can look at the formula and see my problem here it is.

Thanks,

Please Login or Register  to view this content.

**MarvinP** · 01-10-2011, 11:59 PM

Hi Traymond,

What is (Setup,.... just after Index(?

**Traymond** · 01-11-2011, 12:04 AM

sorryy bout that ... SETUP is C15:F44 on Setup Data Sheet

**Marcol** · 01-11-2011, 12:46 AM

Just a guess, your cell refs might be a bit adrift from the sample code

Try

Please Login or Register  to view this content.

Where SETUP is the missing named range I have added.

Change the values in the brown cells to check this out.

Hope this helps

**MarvinP** · 01-11-2011, 12:52 AM

Hi,

Look at the attached and see if a simple index doesn't do what you need. I'm a little confused from your first attach as you didn't have the named range in it.