• 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 and return the value that met multiple criterias

S

saamrat

Member
Dear Fellow Chandoos,

I am stuck with a problem. Lookup for the value in Cell G2 and search data in A:C and copy those results in F:H.
Excel sheet attached. Kindly help
 

Attachments

  • Sort_Excel.xlsx
    10.1 KB · Views: 6
saamrat
You could start Macro Recorder and You'll get basic code from that.
After few modifications, it would be useful.
or
test this sample
 

Attachments

  • Sort_Excel.xlsb
    17.2 KB · Views: 7
Hi,​
​
easily doable with Excel basics so without any code via a filter or an advanced filter,​
the same by code, just needing an unique codeline with an advanced filter …​
​
 
You must log in or register to reply here.
Back
Top