=if(B2=vlookup(A2,Table,2,false),"TariffA","Tariff B")

--
Regards,
Tom Ogilvy


"Paul" wrote in message
oups.com...
Say I have a table for phone commission

---------------------------
Handset - TariffA - TariffB
---------------------------
Nokia1 - £50 - £100
Nokia2 - £60 - £200
Sony1 - £60 - £300
---------------------------

and on another sheet I have

---------------------------
Handset - Expected - Actual
---------------------------
Sony1 - £300 - x
---------------------------

I know I have a Sony1, and that I have £300 - how do I return
"TariffB" as the cell value, X?

Any ideas on how to do this?