ashley1974
New Member
- Joined
- Oct 28, 2004
- Messages
- 3
HI
I have a large table Coumn A = date b = amount, c is irrelevant, this set of 3 is repeated a few times horizontally with various dates and figures. Each horizontal line has a specific currency code. What i need is to have 1 cell at the end of this array and lookup each date (A2)find the rate on another sheet then multiply it to the (b2) then add to (a4) at specific rate.
The date field columns A,D,G have varying dates which i need to find a corresponding rate on another sheet.
Can anyone help
I have a large table Coumn A = date b = amount, c is irrelevant, this set of 3 is repeated a few times horizontally with various dates and figures. Each horizontal line has a specific currency code. What i need is to have 1 cell at the end of this array and lookup each date (A2)find the rate on another sheet then multiply it to the (b2) then add to (a4) at specific rate.
The date field columns A,D,G have varying dates which i need to find a corresponding rate on another sheet.
Can anyone help