Hello - I've been reading through a few posts to try and figure out how to solve my problem, but can't seem to get it right I've tried a combination of formulas using vlookup's, index and match to no avail...
Anyway, I've attached a sample file. Essentially, I want to select a region and month on the 'Validation' tab from the two independent data validation lists and have the data (revenue) populate in cells C7-G7 for Products A - E for the respective region and time period. (The source tab is titled 'Data')
Please let me know if I need to clarify anything - but I think it'll be pretty straight forward once you view the file. Really appreciate any and all help on this, thanks in advance!
Bookmarks