Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two worksheets with the following Data in each column
Sheet 1 A B C D 1 1000 14/08/2008 10:20 15/09/2008 13:45 2 1002 19/08/2008 21:00 17/09/2008 23:55 3 1003 22/08/2008 06:55 22/09/2008 19:35 4 1006 29/08/2008 02:20 25/09/2008 05:15 Sheet 2 A B C D 152 1001 12/08/2008 00:25 10/09/2008 18:35 153 1000 18/08/2008 10:20 15/09/2008 13:45 154 1002 24/08/2008 21:00 17/09/2008 23:55 155 1003 28/08/2008 06:55 22/09/2008 19:35 In column E on Sheet 2 I would like to see the date from Column C on Sheet 1 where the number in Column B Sheet 2 matches the number in Column B Sheet 1 and where their is no match then return "blank" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
second or third match in vlookup() or Match() | Excel Worksheet Functions | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions |