| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index and matching with string search!
hi
in sheet1 i'm having 2 col thru a1:b6 VALUE CODE 100 DDP 111 50 DDP 222 200 DD 666 500 DT 030208 DDP 444 600 DP 555 in sheet2 two col thru a1:b10 CODE VALUE 111 100 222 50 444 500 333 200 555 600 666 200 777 100 888 200 999 400 how can i index col B (value) by matching col A (code) in sheet2 with col B (code) in sheet1? help pl! -via135 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| string matching | Excel Worksheet Functions | |||
| search if a string contains text matching items in a list | Excel Worksheet Functions | |||
| index and matching in userform! | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Index & Matching Functions | Excel Discussion (Misc queries) | |||
Threaded Mode
