Hi Guys,
I'm looking to pull data from Sheet-2 onto Sheet-1 Summary table (see attached).
Basically what I want to see on the summary table (sheet-1), is that whatever value I pick on the drop down list, the corresponding monthly and yearly costs should populate from sheet-2.
Issue is that I have merged cells/headers on row-1 (e.g. US, UK, Japan). I understand that creating drop-down list using merged cells is probably not ideal, so open to other suggestions for creating a drop-down without blanks.
WANT TO USE AN EASY WAY TO SOLVE THIS PLZ!!
Any insight on what logic and functions i could apply would be greatly appreciated.
Cheers!
V
Bookmarks