clandestino800
New Member
- Joined
- Mar 14, 2021
- Messages
- 19
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hi guys!
I am struggeling with a formula, which i i think it can be solved with index and match.
In Sheet1 there are three columns (Names, Proj and Amount) and in Sheet2 I have Proj and the names (vertically)
and I'm trying to get the amounts from Sheet1 assigned to the name.
I'd be very thankful for any help!
Randall
Sheet1
Sheet2
I am struggeling with a formula, which i i think it can be solved with index and match.
In Sheet1 there are three columns (Names, Proj and Amount) and in Sheet2 I have Proj and the names (vertically)
and I'm trying to get the amounts from Sheet1 assigned to the name.
I'd be very thankful for any help!
Randall
Sheet1
Sheet2