Index Match & Names Range Problem

[Barking_Mad]

Hi,

I can't get this to work. Not sure why, any help?

=IF(F3=$I$1,INDEX('Sheet1'!G$14:G$513,MATCH($B3,'Sheet1'!A$14:A$513,0)))

I'd like to replace the references with a named range as the rows might be deleted at some point. This changes to:

=IF(F2=$I$1,INDEX(table1,MATCH($B2,table1,0)))

But I get an error.

[pareshj]

Hi,

Can you share your workbook? it will make it easy to resolve then..

Regards,
Paresh J

[Barking_Mad]

Here's the file

[Barking_Mad]

Ill try, but it will mean remove sensitive data, give me 10 mins!

[mcmahobt]

Try this instead - you'll have to change the named range formula though.