Hi everyone,
I have a problem which I'm sure should be simple to solve but for the life of me I can't work it out.
Below is a snippet of the workbook I'm using, I've combined parts of two sheets into one for this photo:
On the right hand side is a list of orders being exported from our site.
On the left is a table of the various product codes we are using.
All we want to do if for the cell K3 to display the correct product type based on the number in J3 and the table on the left. The amount of products will continue to expand, so it needs to be dynamic.
I've been using index & match when using a matrix and I have two search criteria, but I'm struggling to solve this with only one.
Really appreciate any help.
Thank you,
Capture.JPG
Bookmarks