Good morning,
I'm trying to figure out a formula for this
Sheet 1
Part # Stock
390-2 | function
219-2 |
210-3 |
Sheet 2
unique value | space | unique value
part # | stock | space | part # | stock
Any insight?
Thanks
I'm trying to figure out a formula for this
- Look horizontally for the unique header value (A B C D E F G)
- Then vertically search column by column for the part # (it's always column 0)
- Give value for stock (always column 2)
Sheet 1
Part # Stock
390-2 | function
219-2 |
210-3 |
Sheet 2
unique value | space | unique value
part # | stock | space | part # | stock
Any insight?
Thanks