reasem
New Member
- Joined
- Nov 15, 2019
- Messages
- 38
Sheet 1
Sheet 2 - DATA
sheet 3 - CALCULATIONS
Is there a way for a formula to spit its results into another sheet? I don't want any formulas on sheet 1 because the data tab may not have the document ID that I want to pull. I'd like all the formulas to be on the calculations tab.
NOTE: I'm trying to pull both the Document ID and Date based on the Account # found in the description on sheet 2
If possible, what is the easiest way to do this?
Account # | Document ID | Document Date |
---|---|---|
789-789 | ||
123-123 | ||
456-456 |
Document ID | Document Date | Description |
---|---|---|
52 | 08/24/2019 | ORIGINAL 123-123 T-5 |
56 | 7/02/2018 | 456-456 F-10 |
69 | 10/09/2019 | 789-789 |
Is there a way for a formula to spit its results into another sheet? I don't want any formulas on sheet 1 because the data tab may not have the document ID that I want to pull. I'd like all the formulas to be on the calculations tab.
NOTE: I'm trying to pull both the Document ID and Date based on the Account # found in the description on sheet 2
If possible, what is the easiest way to do this?