I want to do the following:

I have data which says

Postcode Equipment 1 Equipment 2
SE David Bob
B Bill James

and I have sales

Invoice Value Postcode Equipment type
1 £10 SE 1
2 £20 SE 2

and I want a formula to return the name of the sales rep depending on
equipment type.

I have entered

=IF(U2,"Acute
Care",(VLOOKUP(V2,Salespersons!A:C,2,FALSE)),VLOOK UP(V2,Salespersons!A:C,3,FALSE))

U2 = Equipment type
V2 = Postcode

This is wrong so can anyone help please?