| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to get examples to work for lookup etc
I have just a very simple thing to accomplish but I guess I am just not getting it. I am comparing two columns of data, larger against small column, taking the matching results to a separate column then the non-matching column to another. I have used a dynamic range for each column. Biglist Littlelist Matches NonMatches 123456789 123654789 123654789 236548925 123456789 245987445 665713235 461876212 236548925 124598792 123456789 114532215 461876212 665713235 165645136 124598792 123436789 245987445 114532215 124598792 665713235 165645136 I have used the differant examples here, and elsewhere and I am not able to get the Functions to work with INDEX or MATCH even when nesting the Formula.  Any help would be very appreciated. -- BrandonC ------------------------------------------------------------------------ BrandonC's Profile: http://www.excelforum.com/member.php...o&userid=36504 View this thread: http://www.excelforum.com/showthread...hreadid=562665 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| Work Rota - Do I need a formula? | Excel Discussion (Misc queries) | |||
| Unable to read File | Excel Worksheet Functions | |||
| Change Path names in copied work book | Excel Worksheet Functions | |||
Threaded Mode
