PDA

View Full Version : VLook Up with Multiple criteria



aks.1982
04-13-2013, 03:48 AM
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
04-13-2013, 08:17 AM
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
04-13-2013, 09:42 AM
Thanks Sam...