Formula needed?
1. I have a worksheet that is populated with invoicing information. (who, date, model, qty,$, etc…) called “saleslog” which is added to everyday.
2. Another sheet called “salesform” I would like to populate with information from “saleslog” .
3. “Salesform” is already set-up except for qty of each item ordered, who and date.
4. THE PROBLEM: In “saleslog” there are multiple rows for each order, representing each model ordered but they will have the same who and date, but on different dates they may have the same model.
5. I have set-up the “salesform” so it has the correct date and who but have not been able to fiqure out the formula to use to find qty to match model. As qty will always be within the same range as who and date.
How do I validate the vlookup so that it will search only the correct range of “saleslog”. Or is vlookup the correct function?
Any help or suggestion would be appreciate as this has taken up most of today trying different functions.
I will be doing this in vba, but would just like to get the formula working on the worksheet.
Thanks.
-D
1. I have a worksheet that is populated with invoicing information. (who, date, model, qty,$, etc…) called “saleslog” which is added to everyday.
2. Another sheet called “salesform” I would like to populate with information from “saleslog” .
3. “Salesform” is already set-up except for qty of each item ordered, who and date.
4. THE PROBLEM: In “saleslog” there are multiple rows for each order, representing each model ordered but they will have the same who and date, but on different dates they may have the same model.
5. I have set-up the “salesform” so it has the correct date and who but have not been able to fiqure out the formula to use to find qty to match model. As qty will always be within the same range as who and date.
How do I validate the vlookup so that it will search only the correct range of “saleslog”. Or is vlookup the correct function?
Any help or suggestion would be appreciate as this has taken up most of today trying different functions.
I will be doing this in vba, but would just like to get the formula working on the worksheet.
Thanks.
-D