Pulling data onto a 2nd excel sheet

[MartinLarkin]

Hey Everyone,

I have a sales sheet that will have on the same row - revenue booked and 1 possibly 2 names of consultants involved in that deal.
I want to be able to pull that revenue amount through onto a second sheet and allocate it against either 1 or both the names on a sales table (there is a drop down on sheet 1 to input the names onto the row)

Whats the best formula to use for that and is it possible?

 

[Kaper]

Probably the easiest way will be by Power Query (two 2-columns queries combined), but as you have version 365 - it can be done also with new built-in functions.