Say I have a table for phone commission
---------------------------
Handset - TariffA - TariffB
---------------------------
Nokia1 - =A350 - =A3100
Nokia2 - =A360 - =A3200
Sony1 - =A360 - =A3300
---------------------------
and on another sheet I have
---------------------------
Handset - Expected - Actual
---------------------------
Sony1 - =A3300 - x
---------------------------
I know I have a Sony1, and that I have =A3300 - how do I return
"TariffB" as the cell value, X?
Any ideas on how to do this?
Bookmarks