I see now at bottom of post where your cell references are. Adjusting formula:

=INDEX(Salespersons!A:C,MATCH(V2,Salespersons!A:A, 0),U2+1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Natalie" wrote:

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?