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?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]My #[/TD]
[TD]My description[/TD]
[TD][/TD]
[TD]Vendor #[/TD]
[TD]Vendor description[/TD]
[/TR]
[TR]
[TD]DAL400C[/TD]
[TD]ABC[/TD]
[TD][/TD]
[TD]AC400[/TD]
[TD]LMN[/TD]
[/TR]
</tbody>[/TABLE]
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)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]My #[/TD]
[TD]My description[/TD]
[TD][/TD]
[TD]Vendor #[/TD]
[TD]Vendor description[/TD]
[/TR]
[TR]
[TD]DAL400C[/TD]
[TD]ABC[/TD]
[TD][/TD]
[TD]AC400[/TD]
[TD]LMN[/TD]
[/TR]
</tbody>[/TABLE]
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.