Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookups & match ????
Hi Can anybody help?? I am trying to lookup a numeric value amonsgt text in
a colunm, match this numeric value exactly in another column and then return a value from a third column to a new column. For example: column 1, cell 1 'corr/joebloggs/445544/transfer' I want to find the '445544' sitting in column 2, then return a value (say 12345) sitting in column 3 to a new column, 4 Its confusing me just writing this!!! Please help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating, match, lookups | Excel Worksheet Functions | |||
How to use index match for multi lookups? | Excel Worksheet Functions | |||
INDEX / MATCH performance for lookups | Excel Worksheet Functions | |||
lookups and match | Excel Worksheet Functions | |||
Lookups vs Match | Excel Worksheet Functions |