BrandonBerner
New Member
- Joined
- Mar 16, 2019
- Messages
- 15
I'm back, with another headache haha.
I have 2 Sheets.
Sheet 1 - Is user-friendly
Sheet 2 - Is a database full of product information.
Sheet 1 currently looks like...
<tbody>
</tbody>
Sheet 1 should look like...
<tbody>
</tbody>
Here are 2 NON-WORKING formula to explain what I'm trying to achieve...
Sheet 2 looks like...
<tbody>
</tbody>
I have 2 Sheets.
Sheet 1 - Is user-friendly
Sheet 2 - Is a database full of product information.
Sheet 1 currently looks like...
A | B | |
1 | [In Stock?] | [Product Name] |
2 | ? | Product #3 |
3 | ? | Product #2 |
4 | ? | Product #4 |
5 | ? | Product #1 |
<tbody>
</tbody>
Sheet 1 should look like...
A | B | |
1 | [In Stock?] | [Product Name] |
2 | No Stock | Product #3 |
3 | In Stock | Product #2 |
4 | In Stock | Product #4 |
5 | No Stock | Product #1 |
<tbody>
</tbody>
Here are 2 NON-WORKING formula to explain what I'm trying to achieve...
HTML:
IF B2=Sheet2!B2:B & If Sheet2!A2>=1, "In Stock", "No Stock"
HTML:
=COUNTIFS((B2,Sheet2!B2:B),MATCH(Sheet2!A2>=1), "In Stock", "No Stock")
Sheet 2 looks like...
A | B | |
1 | [Inventory Count] | [Product Name] |
2 | 0 | Product #1 |
3 | 20 | Product #2 |
4 | 0 | Product #3 |
5 | 40 | Product #4 |
<tbody>
</tbody>