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.


[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Employee ID[/TD]
[TD]Name[/TD]
[TD]Absent[/TD]
[TD]Sick[/TD]
[TD]Late[/TD]
[TD]3 Days Conversation[/TD]
[TD]6 days[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I will feed this data in.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Need to get it from Another sheet where E-ID and 3 days should match[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]ID[/TD]
[TD]Sick Day[/TD]
[TD]Late days[/TD]
[TD]3 days sick[/TD]
[TD]3 days late[/TD]
[TD]6 days sick[/TD]
[TD]6 days late[/TD]
[/TR]
[TR]
[TD]xyz[/TD]
[TD]89999[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD] Look up from another sheet
Return Column#4 value[/TD]
[TD]Look up from another sheet
Return Column#4 value[/TD]
[TD]Look up from another sheet
Return Column#4 value[/TD]
[TD]Look up from another sheet
Return Column#4 valuet [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would love to attach file but i am not able to.

Another sheet 2

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee Id[/TD]
[TD]topic[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3 Days[/TD]
[TD]454623132[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]6 Days [/TD]
[TD]878465456[/TD]
[/TR]
</tbody>[/TABLE]


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.