T
Tahira
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(VLOOKUP(emp
code,'sheet2'!D:R,15,0))=true,""),(IF(ISERROR(VLOOKUP(emp
code,'sheet2'!D:Q,14,0))=true,""),(vlookup(emp
code,'sheet2'!C:O,13,0))=true,"")))))
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(VLOOKUP(emp
code,'sheet2'!D:R,15,0))=true,""),(IF(ISERROR(VLOOKUP(emp
code,'sheet2'!D:Q,14,0))=true,""),(vlookup(emp
code,'sheet2'!C:O,13,0))=true,"")))))