Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching records
Hi, I have a sheet where columns A-D are given, sorted ascending to col A. I have data in another sheet A and B where col A *may* match a value in sheet 1,col A. I need to do this for sheets that may contain up to 3000 rows. The rows may or may not contain the same numbers of rows. I need to match if possible the BarCd located in sheet 2 and bring along the Location column with it and place it in the same row as the matching value in sheet 1. Thanks in advance :) Ray Example:Sheet 1 BARCD - UII - NOMEN 27122 - LDW53W9LD2217 - LCHR GREN RIF M76 MC 27123 - LDW53W9LD2218 - LCHR GREN RIF M76 MC 27126 - LDW53W9L157974 - PISTOL PYRO AN-M8 15 27127 - LDW53W9LE068750 - PISTOL PYRO AN-M8 1 5 29235 - LDW53W9L8036268 - TELEPHONE CELL W/CAM 29238 - LDW53W9L8790941 - TELEPHONE CELLULAR Sheet 2 BARCD - LOCATION 29235 - 13 29240 - 13 29243 - 13 29247 - 13 29250 - 13 29251 - 13 29239 - 13A 29245 - 2074 29238 - 2532 29246 - 3149 29249 - 3325 27122 - 3327 27123 - 3327 27126 - 3327 27127 - 3327 -- RayB ------------------------------------------------------------------------ RayB's Profile: http://www.excelforum.com/member.php...o&userid=33499 View this thread: http://www.excelforum.com/showthread...hreadid=562487 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching records
Ray,
On sheet1, in cell E2: =VLOOKUP(A2,Sheet2!A:B,2,False) or, if you don;t want to see the missing matches as errors: =IF(ISERROR(VLOOKUP(A2,Sheet2!A:B,2,False)),"",VLO OKUP(A2,Sheet2!A:B,2,False)) Copy down to match your columns, and you're done. HTH, Bernie MS Excel MVP "RayB" wrote in message ... Hi, I have a sheet where columns A-D are given, sorted ascending to col A. I have data in another sheet A and B where col A *may* match a value in sheet 1,col A. I need to do this for sheets that may contain up to 3000 rows. The rows may or may not contain the same numbers of rows. I need to match if possible the BarCd located in sheet 2 and bring along the Location column with it and place it in the same row as the matching value in sheet 1. Thanks in advance :) Ray Example:Sheet 1 BARCD - UII - NOMEN 27122 - LDW53W9LD2217 - LCHR GREN RIF M76 MC 27123 - LDW53W9LD2218 - LCHR GREN RIF M76 MC 27126 - LDW53W9L157974 - PISTOL PYRO AN-M8 15 27127 - LDW53W9LE068750 - PISTOL PYRO AN-M8 1 5 29235 - LDW53W9L8036268 - TELEPHONE CELL W/CAM 29238 - LDW53W9L8790941 - TELEPHONE CELLULAR Sheet 2 BARCD - LOCATION 29235 - 13 29240 - 13 29243 - 13 29247 - 13 29250 - 13 29251 - 13 29239 - 13A 29245 - 2074 29238 - 2532 29246 - 3149 29249 - 3325 27122 - 3327 27123 - 3327 27126 - 3327 27127 - 3327 -- RayB ------------------------------------------------------------------------ RayB's Profile: http://www.excelforum.com/member.php...o&userid=33499 View this thread: http://www.excelforum.com/showthread...hreadid=562487 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Matching the same amount of records in one value to another column | Excel Worksheet Functions | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Find matching records in two worksheets | Excel Discussion (Misc queries) |