Confirm whether emp num or names which is available in Sheet1 is present in
Sheet2 also, if it is available in sheet2 then say in which column it is
their in Sheet2?

--------------------
(MS-Exl-Learner)
--------------------



"Tahira" wrote:

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,"")))))