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!

Employee Name	Team	Team Allocation
Marcus Fenix	2	.35
Dom Santiago	3	.50

<tbody>
</tbody>

 

[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.