Attached is a sample of a workbook I'm trying to devise
Basically on Sheet 1 there are some query's that have been pulled from some DBF files and sorted accordingly
On Sheet 2 is the lookup I am struggling with.
What I'm trying to achieve is a VBA code that will reference Cell C1 then return the value 1 cell to the left of of this value in sheet 1 and then repeat until complete. I've added the actually value to be returned highlighted in yellow to clarify.
Many thanks
I don't understand how you can expect this result (31218MAIN11110) as I see multiples rows in sheet1 showing the same barcode 31218? You probably have other criteria you did not mentionned. Also, as you only have 1 barcode in cell C1, the results will allways be the same. No? To me, there is only one answer if there is only one criteria.
I think we need more detailed information on what you want.
Regards
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks