Hello,
I'm hoping you can please assist with the below problem that I'm having:
Essentially, as per the attached spreadsheet I have a row of clients who have associated discounts for certain publications. I would like to have a Data Validation list (B2) which chooses from these publications (D2:DF). When the user chooses a publication in B2 I would like the respective discount to appear in the cell next to the client's name (B3:B15).
The Cell I am currently attempting to use is below:
=INDEX(D3:F15,MATCH($B$2,$D$2:$F$2,0))
Any help would be greatly appreciated!
Bookmarks