User Profile
Heather2050
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Match values from two different columns on two sheets (same workbook) and give result from a 3rd col
Hi, Will try to do this request in bullet point: Workbook will be adding a sheet each day with similar data Need to match certain data from previous day to current day Data will be taken off and added day to day; therefore rows will not be same (VLOOKUP - couldn't work). Columns are not side by side - multiple columns in worksheet. (example shows side by side) - Result column is about 8 columns over from the columns I need to match. Can't figure out how to add attachment - here are the two worksheets. Sheet One Customer requisition Sales order Serial Number 1024-123912 S000001410 F0000237993 B32254 S000000012 F039248709834 R000000493 S000002507 F0000237993 R000000493 S000002522 F0000238801 R000000498 S000002525 F0000457326 R000000498 S000002530 F0000458802 Sheet Two Customer requisition Sales order Serial Number B32254 S000000012 1024-123912 S000001410 R000000493 S000002507 R000000498 S000002525 Hope this helps. Thank you.1.4KViews0likes1Comment
Recent Blog Articles
No content to show