sambanimal2
New Member
- Joined
- Apr 4, 2018
- Messages
- 3
Hi,
I have been following the forum and it has provided me with some helpful tips along the years. However, this time I would have a problem I was not able to find an answer to.
I would like to have a lookup or query function which contains multiple criteria which can also be in "or" format. See the the screenshot below:
The idea is that for each product and the dimension it would search from a table the correct price. If the price cannot be found, it would return some sort of an error code (does not really matter which).
How would this work in excel?
I have been following the forum and it has provided me with some helpful tips along the years. However, this time I would have a problem I was not able to find an answer to.
I would like to have a lookup or query function which contains multiple criteria which can also be in "or" format. See the the screenshot below:
The idea is that for each product and the dimension it would search from a table the correct price. If the price cannot be found, it would return some sort of an error code (does not really matter which).
How would this work in excel?