Populate one cell from mastersheet

Hello everyone,

I am new here and hoping to get some help to a formula or be steered in the right direction.

I would like to populate a cell in the second sheet every quarter from the mastersheet. The 1st sheet is a mastersheet tracking all my clients with respective fees in EUR or US. The second sheet is created like a form letter. I would like to figure out the formula to populate the amount each quarter to the respective clients in the right currency. I am not sure how to go about it, would appreciate if someone would kindly steer me in the right direction, whether to use a SUMIF, IF or VLOOKUP or something else altogether. I am also opened to suggestions in terms of creating an additional sheet if required....etc.

Many thanks,
Michelle

Hi Michelle,

see the attached file. Use the drop-downs in cells A10 and B10 to select the client and the quarter, and the fee and currency will automatically adjust.

Hope this helps.

Pete

Hi Pete,

That is very impressive, it is exactly what I am looking for. May I ask in the last part of the formula RIGHT(B10-1)*4+2)=0,"US","EUR"), what does 4 and 2 refer to? The excel sheet I posted is just a dummy version and I am hoping to recreate the formula in the official excel book.

So grateful for your help!

Michelle