You have attached the file (thanks), and said what you think you need to use - but you forgot to tell us WHAT you are trying to do?
I have a feeling you need to use INDEX/MATCH
Which table is data, and which 1 is output?
I also suggest that you use the exact same headings in both tables
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hi FDibbins..
given the two tables, i need to vlookup the qty column (output) on the left table from the right table (data table).
im having problems due to multiple columns on both tables.
Originally Posted by FDibbins
Do you mean that the Site Name columns (A to D) could be either in Site a1 or Site a2 columns ?
It would help if you gave some idea of what you are expecting - please manually mock up some expected results and re-attach your workbook.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks