Array formula - Aladin?
Posted by Russell Hauf on November 20, 2001 10:42 AM
...or anybody else that can help...
Ok, here's my problem, which should be easy for you. I tried to look up some past examples, but couldn't find what I wanted (at least not in a short period of time).
Sheet1:
ABC1, 1, 1, $4;
ABC1, 1, 2, $5;
ABC1, 1, 3, $2;
ABC1, 2, 1, $0;
ABC1, 2, 2, $6;
ABC1, 2, 3, $7;
...
ABC7, 22, 1, $66;
ABC7, 22, 2, $9;
ABC7, 22, 3, $1;
(There are actually more columns on sheet1, which I will also want to pull from, but let's make this easy)
And on Sheet2:
ABC1, 2, 1;
ABC1, 2, 2;
ABC1, 2, 3;
--what I want to do is to bring in the 4th column from Sheet1 (dollar amounts) to Sheet2. I can't seem to do this with a simple "IF" array function (possibly because of the 3rd column numbers repeating?). Also, the numbers in the third column go higher than 3, and vary for each value in column A.
Thanks in advance,
Russell