vlookup return multiple values?

[victornadi]

Hi,

What I am looking at doing is, search for the value of activity which is acc (sheet 1) , in sheet 2. Problem is there is more then 1 correct work for the activity code for example acc can be either wire or comp. But not drive. What's the best way of coming up with a formula that will show that their is a match in between sheet 1 and sheet 2. There are also additional column in between the heading activity and work.



sheet1
actvy work

acc wire
acc wire
acc drive
acc comp
acc comp


sheet 2 work

acc wire
acc comp

Thanks

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.




To add a file to a post