Hi -- Can someone help me with this formula?
=INDEX(INDIRECT("'"&DealPlatformType&"
Platform'!I90:I98"),MAX(1,MATCH(Planner!DealBlockS ize,INDIRECT("'"&DealPlatformType&"
Platform'!F90:F98"),1)))+VLOOKUP(Planner!DealBlock Size,INDIRECT("'"&DealPlatformType&"
Platform'!F90:H98"),3)*(Planner!DealBlockSize-(VLOOKUP(Planner!DealBlockSize,INDIRECT("'"&DealPl atformType&" Platform'!F90:I98"),1)))

I need it to only lookup a value now and not do do so much so for example
someone inputs a size and it goes to another tab based on which platform
they choose and then picks the price directly across from it
so it someone picks 250 it should go to the right tab and pick 250 and then
the price directly across from it?

Can anyone help?

Thank you