tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Really stuck on this
I have to find a product price for the data I have in sheet "Products" from Sheet "Prices"
any I don't find I need a "No Match" input to the cell!
heres what I need to do
the products are described using 4 columns in sheet Products
AA,SKU
AB,size
AC,Num Pages
AD Quantity
AE is where I want to return a price
so heres my problems
Sheet Prices
Has "SKU" in Column A, so fist we need to match the SKU, but there will be more than One row that matches
Product size In Column B, again not unique
the we have Number of Pages and this is listed as a number in Sheet Products but a range using two columns in sheet Prices
so heres what I need to be able to look at the page size and see which row it fits in by page size
I will do I diagram below to make this simpler
and the same with quanity.
how can I look up the price>
Visial Diagrams
Sheet Products (there is a lot more data then in this example!)
<tbody>
</tbody>Sheet Prices
<tbody>
</tbody>
I hope this gives an example of what I need happy to add any extra rows if needed
please help if you can
Tony
Really stuck on this
I have to find a product price for the data I have in sheet "Products" from Sheet "Prices"
any I don't find I need a "No Match" input to the cell!
heres what I need to do
the products are described using 4 columns in sheet Products
AA,SKU
AB,size
AC,Num Pages
AD Quantity
AE is where I want to return a price
so heres my problems
Sheet Prices
Has "SKU" in Column A, so fist we need to match the SKU, but there will be more than One row that matches
Product size In Column B, again not unique
the we have Number of Pages and this is listed as a number in Sheet Products but a range using two columns in sheet Prices
so heres what I need to be able to look at the page size and see which row it fits in by page size
I will do I diagram below to make this simpler
and the same with quanity.
how can I look up the price>
Visial Diagrams
Sheet Products (there is a lot more data then in this example!)
AA | AB | AC | AD | AE | AF | |
1 | SKU | Prod size | Num Pages | Quantity | Price? | AE is what i'm trying to find |
2 | 111222333 | 10x12 | 10 | 1 | £6 (this is what I need to find!) | matchs row 4 |
3 | 222333444 | 10x12 | 10 | 1 | No Match | No Match |
4 | 111222333 | 10x12 | 25 | 15 | £12 | matchs row 7<strike></strike> |
5 | 111222333 | 12x12 | 25 | 1 | etc all the way down the rows | |
6 | 222333444 | 12x12 | 10 | 7 | ||
7 | 555555555 | 10x10 | 10 | 7 | ||
8 | 555555555 | 12x12 | 25 | 1 | ||
9 | 111222333 | 10x12 | 10 | 15 |
<tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | |
1 | SKU | Prod Size | Pages From | Pages To | Quantity From | Quantity To | Price | ||||
2 | 111222333 | 10x10 | 1 | 100 | 1 | 100 | £5 | ||||
3 | 111222333 | 10x12 | 1 | 7 | 1 | 100 | £4 | ||||
4 | 111222333 | 10x12 | 8 | 15 | 1 | 5 | £6 | ||||
5 | 111222333 | 10x12 | 8 | 15 | 6 | 100 | £9 | ||||
6 | 111222333 | 10x12 | 16 | 100 | 1 | 10 | £10 | ||||
7 | 111222333 | 10x12 | 16 | 100 | 11 | 100 | £12 | ||||
8 | |||||||||||
9 | |||||||||||
10 | |||||||||||
11 | |||||||||||
12 | |||||||||||
13 | |||||||||||
14 |
<tbody>
</tbody>
I hope this gives an example of what I need happy to add any extra rows if needed
please help if you can
Tony