Too Many "Nests"

[groundin]

Hi,
I have a formula that exceeds the nesting limit on excel. I there any way I can re-write this formula to shorten the nesting amount? I am nested to 84 currently and limit is 64 I believe. Here is a partial sample of what the formula looks like.

=IF('Start Page'!$J20=Costs!$BC$1,Costs!$BB$1,IF('Start Page'!$J20=Costs!$BC$2,Costs!$BB$2,
IF('Start Page'!$J20=Costs!$BC$3,Costs!$BB$3,IF('Start Page'!$J20=Costs!$BC$4,Costs!$BB$4,
IF('Start Page'!$J20=Costs!$BC$5,Costs!$BB$5,IF('Start Page'!$J20=Costs!$BC$6,Costs!$BB$6,
""))))))))))))))))))))))))))))) etc to 84 "nests"

Any help would be appreciated,
Thanks

[oeldere]

problaby it can be done with index / match.

to be sure you have to add an excel file, without confidentional information.

Maybe you can try this one:

=index(Costs!$BB$1:$BC$84,match('Start Page'!$J20,Costs!$BC$1:$BC$84,0),-1)

[groundin]

Thanks, I will play around with that and let you know how it works out

[groundin]

Thanks worked great, just had to tweak a bit and came up with the following to avoid any #N/A errors.
Thanks for your help!

=IF(ISERROR(INDEX($BC$1:$BC$84,MATCH('Start Page'!$J20,Costs!$BC$1:$BC$84,0))),"",INDEX($BC$1:$BC$84,MATCH('Start Page'!$J20,Costs!$BC$1:$BC$84,0)))

[oeldere]

Since you use excel 2007 it can be done with

=iferror(INDEX($BC$1:$BC$84,MATCH('Start Page'!$J20,Costs!$BC$1:$BC$84,0),"")

Just to be curious.
Your formula works?

You don't add a columnreference in it, so i'm wondering if it will work for you.

Please reply

[groundin]

Here it is again, yes it works great.

=IF(ISERROR(INDEX($BC$1:$BC$84,MATCH('Start Page'!$J20,Costs!$BC$1:$BC$84,0))),"",INDEX($BC$1:$BC$84,MATCH('Start Page'!$J20,Costs!$BC$1:$BC$84,0)))