Try
=INDEX(INDIRECT(I2),MATCH(F2,INDIRECT(I2 &"[Width]"),0),MATCH(E2&"",INDIRECT(I2 &"[#Headers]"),0))
Use INDIRECT to reference the value in I2: I have included Nick's formula (bold)
Try
=INDEX(INDIRECT(I2),MATCH(F2,INDIRECT(I2 &"[Width]"),0),MATCH(E2&"",INDIRECT(I2 &"[#Headers]"),0))
Use INDIRECT to reference the value in I2: I have included Nick's formula (bold)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks