VLook Up with Multiple criteria

[aks.1982]

Hi,

Please find the attached file,

I Have a Countif and VLookUp function in summary work sheet cell No "D2"
i need to cross check the employee no that is A2:A31 with Man! B4:B8,
if it matches then only it should proceed to the next steps.

Any Suggestions.

Thanks,
Ak

[SamT]

Formula is
IF(VLookup formula = Desired Result[Comma]Formula[Comma]Double quotes ("")

Desired Result can be a formula
Formula after first Comma is evaluated if the Expression before the first Comma is true.
Formula after the second Comma is evaluated if the Expression is false.
Formula (Double Quotes) = Leave Cell blank.

[aks.1982]

Thanks Sam...