Hello guys, not been around for a while but need help to find best solution to this problem.
I have a worksheet in which I input main data for use with other worksheets.
There about 8,000 lines of data currently in this worksheet with information in 5 columns.
1) Date
2) Customer Number
3) Item Number
4) Amount Paid
5) Residual
Columns 1-4 contain data on every line but column 5 (Residual) only contains data as and when required.
From another worksheet, I need to automatically input the 'Residual' value but only when the 'Date' + 'Customer Number' + 'Item Number' are true, as dictated by inputs in the 2nd worksheet.
I would sum up the equation as follows:
If 'Date' + 'Customer Number' + 'Item Number' on 2nd worksheet occur on the same horizontal line in 1st worksheet; then output 'Residual'.
Have tried various combinations but none have been successful.
All suggestions welcome ...thanks!
Bookmarks