anand_g1987
New Member
Hi,
I am a new member to this forum.
i need a help with excel formula related to Index & match & i have uploaded the excel file.
in this both X axis & y axis are variable & chart has just nearest whole number. i tried to put index and match formula but its taking next cell. i need like this if i enter thickness = 1.65 it should take 1.8 & if i enter 255, it should take 300.(check the attached file)
also width above 500 mm should take last column & width below 100 mm should take 1st column. please help.
Thanks in advance
I am a new member to this forum.
i need a help with excel formula related to Index & match & i have uploaded the excel file.
in this both X axis & y axis are variable & chart has just nearest whole number. i tried to put index and match formula but its taking next cell. i need like this if i enter thickness = 1.65 it should take 1.8 & if i enter 255, it should take 300.(check the attached file)
also width above 500 mm should take last column & width below 100 mm should take 1st column. please help.
Thanks in advance