I assume even though you posted a .xlsx file you have xl2003. if so revise the formula to not use IFERROR
M4: =IF(J1="yes",IF(ISERROR(INDEX(B4:K7,P5,P4)),"Size Out",INDEX(B4:K7,P5,P4)),0)
I assume even though you posted a .xlsx file you have xl2003. if so revise the formula to not use IFERROR
M4: =IF(J1="yes",IF(ISERROR(INDEX(B4:K7,P5,P4)),"Size Out",INDEX(B4:K7,P5,P4)),0)
i had missed the "" of off yes in m4 which would explain the #name error but i am still getting the #ref error in p5 , sorry to be a pain im a bit of a novice at this
brian
the name error was caused by missing out """" on yes , even with the new formula i am still getting the #ref error
brian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks