Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match !
Hi All,
I have workbook with 2 sheets, sheet1 & sheet2. sheet1 data as follows: Group Id Code Status 125 ABC_DE completed 127 ACD_EF completed 130 ERD478 completed 131 EREDS completed sheet2 Codes Status ABC_D ACD ERD478 EREDS By observation u can say only ERD478 & EREDS is exactly matching so i want the status of that particular code. Result 1 : Assume sheet1 has ABC as code, in sheet2 I have ABCDEF - here in this case only part matching here also i want the status. Result 2 : If i want to match both Group Id and Code ( assumed sheet2 has Group Id). Result 3 : If i want to match Codes ( sheet2 ) with Group Id & Codes of sheet1. ( assumed some codes are appeared in Group Id) All the above results,I want in VBA. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |