• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    vlookup multiple worksheet question [SOLVED]

    Hi Narayan I didnt understand how you created the "sheetlist".Also would like to know if data are more in one sheet and less in other sheet. will this formula work. INDIRECT("'"&INDEX(sheetlist,MATCH(1,--(COUNTIF(INDIRECT("'"&sheetlist&"'!$A$1:$c$4"),A4)>0),0))&"'!$A$1:$c$4")
  2. P

    Match multiple cells against One cell and return the vlookup value

    Eg A B C D E F 431960 N01743 N01745 A02107 N01301 N01386 Match B to F and return the A value ie N01386=431960
Back
Top