• 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.

Recap data use Vlookup & multisheet

stormania

Member
Dear Master

How to fill in recap data use a make a simple formula to vlookup data in multiple sheet? but not one by one vlookup per sheet
As per data in attach file

Thank in advance
 

Attachments

  • Multiple sheet.xlsx
    19.9 KB · Views: 8
In Recap sheet type in Cell C4 and drag over and down.
=VLOOKUP($A4,INDIRECT("'"&C$3&"'!A2:C10"),3,0)
 
Back
Top