BrandonBerner
New Member
- Joined
- Mar 16, 2019
- Messages
- 15
FIRST POST! Wehoo!
Excuse my lack of excel knowledge...Im trying haha.
Thank you for taking the time to open this, and give it a read
Objective:
3 ways to demonstrate what I am trying to achieve.
Here are real formulas that I have tried.
....A...................B...............................C...............................D
<tbody>
</tbody>
Excuse my lack of excel knowledge...Im trying haha.
Thank you for taking the time to open this, and give it a read
Objective:
3 ways to demonstrate what I am trying to achieve.
- Way #1 : D=(C1, B1:B), A1
- Way #2: Search B1:B for absolute match in C1. Once match found, find row of match, and display cell A*.
- Way #3: Find $C1 Product #5, In B1:B (found at B5), display A5 (since thats where Product #5 was found in B5) in $D1
Here are real formulas that I have tried.
- Way #1 : =IF(COUNTIF($B$1:$B,$C1), A*,"Not Found")
- I don't know how to formulate A*
....A...................B...............................C...............................D
SKU | Product Name | Data Validation | SKU (Repeat) |
100 | Product #1 | Product #5 | 500 |
200 | Product #2 | Product #1 | 100 |
300 | Product #3 | Product #8 | 800 |
400 | Product #4 | Product #8 | 800 |
500 | Product #5 | Product #6 | 600 |
600 | Product #6 | Product #8 | 800 |
100 | Product #7 | Product #2 | 200 |
800 | Product #8 | Product #9 | 900 |
<tbody>
</tbody>