Enzo_Matrix
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 113
I am trying to create a price list and the vendors part numbers and descriptions are different that our database. I would really prefer not to go through thousands of items one by one and change them. Is there a way to use a partial reference system?
<tbody>
</tbody>
I need to be able to put in my part number and have it populate our description, however, these should reference the Vendor # as I have pricing associated with those values.
Code:
=Index(Match)
=if(VLOOKUP)
My # | My description | Vendor # | Vendor description | |
DAL400C | ABC | AC400 | LMN |
<tbody>
</tbody>
I need to be able to put in my part number and have it populate our description, however, these should reference the Vendor # as I have pricing associated with those values.