Results 1 to 5 of 5

index match from multiple sheets

Threaded View

  1. #1
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    index match from multiple sheets

    Hello friends

    In excel 2003 i have three sheets
    calculate
    fsr_ngp
    fsr_akl

    Now i have taken data from fsr_ngp with below formula and its work perfectly.
    =INDEX(FSR_NGP!$C:$C,MATCH(I5,FSR_NGP!$F:$F,0))

    But i required data from fsr_akl sheet if some data in this sheet with using above formula.

    In view of the above confirm
    Last edited by avk; 10-13-2011 at 04:27 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1