Vlook with Multiple criteria

[Crescendo]

Hello All,
I am looking forward for some help regarding Vlook with multiple criteria.

Basically i am looking forward to get data from one sheet after it meet both criteria.

If Instance, If Employee Id match than please look for date and return Column C value.

Employee ID	Name	Absent	Sick	Late	3 Days Conversation	6 days
I will feed this data in.					Need to get it from Another sheet where E-ID and 3 days should match

<tbody>
</tbody>

Please help me with this and appreciate it.

 

[snipescc]

Can you provide some sample data, and what you want it to look like?

You can concatenate 2 or more cells together to get your lookup range, if that is helpful.

 

[Crescendo]

Name	ID	Sick Day	Late days	3 days sick	3 days late	6 days sick	6 days late
xyz	89999	6	0	Look up from another sheet Return Column#4 value	Look up from another sheet Return Column#4 value	Look up from another sheet Return Column#4 value	Look up from another sheet Return Column#4 valuet

<tbody>
</tbody>

I would love to attach file but i am not able to.

Another sheet 2

Employee Id	topic	Number
	3 Days	454623132
	6 Days	878465456

<tbody>
</tbody>

This is how it looks. So if agent ID match and than refer to column 3, if column 3 is showing 3 days than return value of column 4 in that tab.
On other side if it match it as 6 days than it should Number in Column title as 6 days. Just easy way to track it down where

Hope it helps or else i can PM you file if you want.