D
Dave
Here is what I would like a formula to do???
I have two workbooks- I will place the formula only in one and extract
data/info. from the other.
What I want the formula to do is...
I want it to search through a column of product codes from the other
workbook (numbers, e.g. 21, 22) and when the desired code (let's say 21) is
detected. I want it to return the information (text info) from a different
column (I.E. transaction description) but the same row as the desired result
(21).
HERE IS WHAT I HAVE BEEN TOLD AND HAVE DONE BUT DOES NOT WORK...
What I get back is a reference error (REF)...Why is this occuring? What can
I do to try to fix it?
If I change the column I want back the only one that gives me anything is 1.
And it just returns 21??
Your product code is in column A of both and your text to return is in
I have two workbooks- I will place the formula only in one and extract
data/info. from the other.
What I want the formula to do is...
I want it to search through a column of product codes from the other
workbook (numbers, e.g. 21, 22) and when the desired code (let's say 21) is
detected. I want it to return the information (text info) from a different
column (I.E. transaction description) but the same row as the desired result
(21).
HERE IS WHAT I HAVE BEEN TOLD AND HAVE DONE BUT DOES NOT WORK...
What I get back is a reference error (REF)...Why is this occuring? What can
I do to try to fix it?
If I change the column I want back the only one that gives me anything is 1.
And it just returns 21??
Your product code is in column A of both and your text to return is in