Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to return data from one column after comparing 2 othe
I am trying to compare 2 worksheets for similar data. I have serial numbers
in column L on Sheet1 and serial numbers in column B on Sheet 2. I want to look for duplicated serial numbers on both worksheets. I need a formula that will search both Sheets for any duplicated serial numbers. When duplicate serial numbers are found, I want the data in column C (Found Date) on sheet2, to auto fill column H (Found Date) on Sheet1. Jeff W |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to return data from one column after comparing 2 othe
In Sheet1,
Put in H2: =IF(ISNUMBER(MATCH(L2,Sheet2!B:B,0)),INDEX(Sheet2! C:C,MATCH(L2,Sheet2!B:B,0)),"") Copy down as far as required. Format as date. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff W" wrote: I am trying to compare 2 worksheets for similar data. I have serial numbers in column L on Sheet1 and serial numbers in column B on Sheet 2. I want to look for duplicated serial numbers on both worksheets. I need a formula that will search both Sheets for any duplicated serial numbers. When duplicate serial numbers are found, I want the data in column C (Found Date) on sheet2, to auto fill column H (Found Date) on Sheet1. Jeff W |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to return data from one column after comparing 2
Works Great. It's Awesome. Thanks Max
-- Jeff W "Max" wrote: In Sheet1, Put in H2: =IF(ISNUMBER(MATCH(L2,Sheet2!B:B,0)),INDEX(Sheet2! C:C,MATCH(L2,Sheet2!B:B,0)),"") Copy down as far as required. Format as date. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff W" wrote: I am trying to compare 2 worksheets for similar data. I have serial numbers in column L on Sheet1 and serial numbers in column B on Sheet 2. I want to look for duplicated serial numbers on both worksheets. I need a formula that will search both Sheets for any duplicated serial numbers. When duplicate serial numbers are found, I want the data in column C (Found Date) on sheet2, to auto fill column H (Found Date) on Sheet1. Jeff W |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to return data from one column after comparing 2
Good to hear that, Jeff. You're welcome.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff W" wrote in message ... Works Great. It's Awesome. Thanks Max -- Jeff W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two columns and return a third | Excel Worksheet Functions | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
Change results , change data in othe cells across the row | Excel Worksheet Functions | |||
Comparing two lists and return specified data | Excel Worksheet Functions | |||
Formula for comparing rows in a column | Excel Discussion (Misc queries) |