Vlookup with IF statement?

[rmrossetti]

Hello All,

I could use some assistance on a lookup scenario!

I would like to populate a cell with a person's name if they meet certain criteria. For instance:

If the person is assigned to a particular team and If the assignment is above 0. if not, the cell should remain blank. Please help!


[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]Team[/TD]
[TD]Team Allocation[/TD]
[/TR]
[TR]
[TD]Marcus Fenix[/TD]
[TD]2[/TD]
[TD].35[/TD]
[/TR]
[TR]
[TD]Dom Santiago[/TD]
[TD]3[/TD]
[TD].50[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

Yes this is do-able, although it's difficult to give an exact formula solution as your cell references are not clear.

But for example, you could do something like this

=if(and(B2=2,C2>0),vlookup(xxx))

Where B2 contains the team, and C2 contains the assignment.

Replace xxx with your actual Vlookup formula.