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

Lookup Data in Different Table..HELP

stormania

Member
Dear Excel Masters

In attach data, kindly help how simple formula to vlookup data in another table (yellow), because i use one by one vlookup.

Thank you
Mast
 

Attachments

  • Data Lookup.xlsx
    20.1 KB · Views: 5
In "SUB" sheet C5, enter formula and copied down to C10 :

=VLOOKUP($A5,'DATA 1'!$A$4:$F$9,MATCH(C$3,'DATA 1'!$A$3:$F$3,0),0)

Then, select C5:C10, copy/paste to E5:E10, G5:G10 and I5:I10

66020

Regards
Bosco
 
Back
Top