| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up a value in one column to another colum
I am trying to check it a item is new. Comparing two columns (900-1500 records)
I using IF(ISNA(LOOKUP(A2,G$2:g$1474)),"","Match") But match is not being returned for any records sample of data Isomedia MAC# Unit ServiceStart Match Div_Lot RegNumber MAC 1023201471 050-0026 1/20/04 050-0026 1023201471 0002A11B2730 1037653266 025-016R 5/25/04 025-016R 1037653266 0002A1188B60 1045954143 0002A11BC470 007-0019 6/11/04 007-0019 1045954143 0002A11BC470 1048849824 0002A119D1F0 051-0004 12/8/04 051-0004 1048849824 0002A119D1F0 1055082119 025-091R 6/9/04 025-091R 1055082119 0002A1192DA0 -- Oscar Kelley HFN Data Analyst Highlands Fiber Network |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I combine column A into Colum B? | Excel Discussion (Misc queries) | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Threaded Mode
