Thank you in advance, Any help would be appreciated.
I have a spreadsheet that contains several columns with headers in which I will copy/paste values in.
I am using Excel 2010.
I want a macro or embedded formula to locate the "ItemNumber" in [DatabaseList] that matches the "ItemNumber" in [MainSheet], based on several columns of values.
again I greatly appreciate your help, I have been struggling with this for some time, I tried vlookup, and even exporting into access and running code based on queries, really I am not sure what to do.
All Information needed to understand exactly what I'm asking is on the attachment.
All items come from a access database, but the question is not about that, the question is about the "ItemNumber" that on MainSheet and the corresponding ItemNumber on the other sheet and its values in the columns I mentioned in the workbook. Please refer to the workbook, start with
MainSheet first.
Thank you...
Bookmarks