rdbauer83
New Member
- Joined
- May 2, 2022
- Messages
- 14
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- Windows
Hi there hope someone can help as I am about to lose it because I know there is something simple. I have a table and I need another sheet to return only cells that match 2 given criteria and aren't empty. I have 2 worksheets and need the information from worksheet 2 to show up on worksheet 1 with given criteria and only cells from worksheet 2 that have information. I have uploaded worksheet 1 without the info, worksheet 2 that has the information needed, and final result which is what I need worksheet 1 to look like. Thank you all for the help!
![Worksheet 1.jpg Worksheet 1.jpg](https://www.mrexcel.com/board/data/attachments/63/63638-3f0fef06aa1773154eb8d20dd1344a97.jpg?hash=Pw_vBqoXcx)
![Worksheet 2.jpg Worksheet 2.jpg](https://www.mrexcel.com/board/data/attachments/63/63637-78e2404dbafd8e7ad065934ff3ff6cea.jpg?hash=eOJATbr9jn)
![Final Result.jpg Final Result.jpg](https://www.mrexcel.com/board/data/attachments/63/63639-209590e692e088997b283c9e192adf5f.jpg?hash=IJWQ5pLgiJ)
![Worksheet 1.jpg Worksheet 1.jpg](https://www.mrexcel.com/board/data/attachments/63/63638-3f0fef06aa1773154eb8d20dd1344a97.jpg?hash=Pw_vBqoXcx)
![Worksheet 2.jpg Worksheet 2.jpg](https://www.mrexcel.com/board/data/attachments/63/63637-78e2404dbafd8e7ad065934ff3ff6cea.jpg?hash=eOJATbr9jn)
![Final Result.jpg Final Result.jpg](https://www.mrexcel.com/board/data/attachments/63/63639-209590e692e088997b283c9e192adf5f.jpg?hash=IJWQ5pLgiJ)