Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup for latest data
I have two sheets, first contains employee details like emp num and names
designation etc.... and second sheet contains the starting date of the employees and 4 other columns withtheir date of extention... extn1, extn2,extn3,extn4 In the first sheet I need the latest date of extention which should be taken from second sheet. first it should considerlatest date from Exten4, if there is no date in that column it should look out for next date in extn3 and bring the date or subsequently repeat the same till it gets date from extn2 ot extn1 I tried the below formulae which did not word =IF(ISERROR(IF(ISERROR(VLOOKUP(emp code,'sheet2'!D:S,16,0))=true,"",(IF(ISERROR(VLOOK UP(emp code,'sheet2'!D:R,15,0))=true,""),(IF(ISERROR(VLOO KUP(emp code,'sheet2'!D:Q,14,0))=true,""),(vlookup(emp code,'sheet2'!C:O,13,0))=true,""))))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Latest LOOKup | Excel Worksheet Functions | |||
always recheck data connection library in MOSS for latest data sou | Excel Discussion (Misc queries) | |||
Lookup / return latest date in range AND value of 1 column to the | Excel Worksheet Functions | |||
lookup latest entered match | Excel Worksheet Functions | |||
Lookup the latest date in a range so it appears as my result | Excel Discussion (Misc queries) |