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)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Oh Yeah!!!!!!!!
It works!
Thanks so much guys! I really appreciate your help.
I can go to bed now with my mind at ease.
Before you nip into bed, can you please mark as solved! ("Thread tools" at top of page)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks