docharding79
New member
- Joined
- Mar 30, 2021
- Messages
- 7
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Office 365
Hi All,
I need help with the attached. The section highlighted in blue is a report that i pull off of our system and the part highlighted in Green is a stock list that i need to create per location.
So i need H2 to have a vlookup to bring back the value in D2 and I2 to return the value in D5. However i need to put in a function that looks at the plant Column C and if it is CT01 it places the available under CT Column H. I hope this makes sense.
Thank you in advance
I need help with the attached. The section highlighted in blue is a report that i pull off of our system and the part highlighted in Green is a stock list that i need to create per location.
So i need H2 to have a vlookup to bring back the value in D2 and I2 to return the value in D5. However i need to put in a function that looks at the plant Column C and if it is CT01 it places the available under CT Column H. I hope this makes sense.
Thank you in advance