O ornshrn New Member May 17, 2014 #1 Hi everyone, I'm trying to calculate the exchange rate from euro currency to US dollar currency using only ranges name and cell name but with limited success. I'd like your support please. If you have any other elegant way i'd appriciate that even more Thanks Oren Attachments Book1.xlsx Book1.xlsx 11.7 KB · Views: 1
Hi everyone, I'm trying to calculate the exchange rate from euro currency to US dollar currency using only ranges name and cell name but with limited success. I'd like your support please. If you have any other elegant way i'd appriciate that even more Thanks Oren
N NARAYANK991 Excel Ninja May 17, 2014 #2 Hi Oren , Sorry , but I am not able to understand your problem ; what do you wish to do ? Narayan
O ornshrn New Member May 17, 2014 #3 Hi Narayan, I wish to transorm all the data from table1 (euro currency) to table 2 (us dollar currency) using only names and structured references formulas. For example: cell c8 is now: =C3*ex_rate but i wish to switch the "C3" to a referenced strucuture from table1 (i think..). I hope this is more clear. Thanks Oren
Hi Narayan, I wish to transorm all the data from table1 (euro currency) to table 2 (us dollar currency) using only names and structured references formulas. For example: cell c8 is now: =C3*ex_rate but i wish to switch the "C3" to a referenced strucuture from table1 (i think..). I hope this is more clear. Thanks Oren
N NARAYANK991 Excel Ninja May 17, 2014 #4 Hi Oren , Is it something like this ? Narayan Attachments Book1 (8).xlsx Book1 (8).xlsx 11.7 KB · Views: 4
O ornshrn New Member May 17, 2014 #5 Hi Narayan, Very nice solution! I didnt think of using COLUMN function. Well done!! Oren
