JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
Trying to put together a formula that I think would be a SUMIF but I may be barking up the wrong tree.
I am using letters to simplify.
I have about 250 names in column A on spreadsheet A.
I have 3 other spreadsheet tabs B, C, D
I put a value and date on spreadsheet A column B & C next to the corresponding name in column A.
In column D I put which spreadsheet this person belongs to B, C or D.
So it should look something like this
What I am trying to do is get this info on spreadsheet A to appear (in the case's above) John's info on spreadsheet B in the same format. Bob's on C and Steve's on C.
Basically from the A spreadsheet I want all the B spreadsheet people show just on B the C's on C and the D's on D
Hope I explained this for everyone to understand.
Appreciate any help
Thank you
James
I am using letters to simplify.
I have about 250 names in column A on spreadsheet A.
I have 3 other spreadsheet tabs B, C, D
I put a value and date on spreadsheet A column B & C next to the corresponding name in column A.
In column D I put which spreadsheet this person belongs to B, C or D.
So it should look something like this
Name | amount | date | spreadsheet |
John | 100 | 11/18/2020 | B |
Bob | 100 | 11/17/2020 | C |
Steve | 100 | 11/16/2020 | D |
What I am trying to do is get this info on spreadsheet A to appear (in the case's above) John's info on spreadsheet B in the same format. Bob's on C and Steve's on C.
Basically from the A spreadsheet I want all the B spreadsheet people show just on B the C's on C and the D's on D
Hope I explained this for everyone to understand.
Appreciate any help
Thank you
James