mistersteve
Board Regular
- Joined
- Aug 18, 2014
- Messages
- 110
- Office Version
- 365
I hope someone can help
I have a list as below
<tbody>
</tbody>
along side there are a few tables
<tbody>
</tbody>
after inputting the account and product in my top list I would like a lookup that matches the account then finds the product.
this would then fill in the price, UOM (unit of measure), and discount.
thanking you in advance
Steve
I have a list as below
Account | Product | Price | UOM | Discount |
Adam | Apple |
<tbody>
</tbody>
along side there are a few tables
Account | Adam | ||
Product | Price | UOM | Discount |
apple | 20 | 100 | 50 |
banana | 25 | 100 | 40 |
pear | 5 | 1 | |
Account | Mary | ||
Product | Price | UOM | Discount |
banana | 3 | 1 | |
grape | 30 | 100 | 25 |
orange | 25 | 100 | |
Account | Peter | ||
Product | Price | UOM | Discount |
apple | 25 | 100 | 80 |
grape | 3 | 1 | 30 |
orange | 20 | 100 |
<tbody>
</tbody>
after inputting the account and product in my top list I would like a lookup that matches the account then finds the product.
this would then fill in the price, UOM (unit of measure), and discount.
thanking you in advance
Steve