Hi everyone, I'm new to posting on here, but I am looking for a formula to solve the following problem:
I have attached a sample spreadsheet
Notes: a model is available in multiple colours as shown in Table 2. i.e Model 1027 C11, C2, C45, C68
I am looking for a formula to enter into Table 1 cell C5 (and copy down) that will look up the model number (cell A5) and colour (cell B5) and see if that combination appears in table 2
Hope someone has some ideas as I have hit a brick wall?
Screenshot 2020-06-29 at 17.10.35.png
Many thanks
Bookmarks