Results 1 to 2 of 2

Thread: index match match

  1. #1

    index match match



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    have been practising a two way lookup but keeping getting a error message, have retraced my steps but to no avail

    had read it might be a ctrl shift enter problem , but havent much knowledge of array formulas


    any help much appreciated

    stu
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	index.jpg 
Views:	10 
Size:	97.3 KB 
ID:	2454  
    Attached Files Attached Files

  2. #2
    Change formula
    =INDEX(B11:F19,MATCH(B3,B11:B19,0)*MATCH(C3,B11:F11,0))
    as
    =INDEX(B11:F19,MATCH(B3,B11:B19,0),MATCH(C3,B11:F11,0))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •