Search code examples
google-sheetsmatchgoogle-sheets-formulaarray-formulasgs-vlookup

Google Sheets Index Match Not Found

Working on a spreadsheet to list inventory items for sale in bulk. Wanting it to automatically generate a "Condition Note" for each item based on it's SKU and Category.

Have a sheet named "Description Table" that has Condition Notes arranged by Category (row) and Condition (column.) The last 2 digits of the item's SKU determine its condition.

This is the formula I have so far, but it's giving an error that it's not finding the row in the MATCH evaluation, specifically "Did not find value '43' in MATCH evaluation." 43 is located in A6 of the Description Table sheet. Any ideas?

=INDEX('Description Table'!A1:J23,MATCH(RIGHT(C2,2),'Description Table'!A:A,0),MATCH(B2,'Description Table'!1:1,0))

Here's the spreadsheet: https://docs.google.com/spreadsheets/d/1SBtJicsKlxykBfKwwLyeHV__ope-D1lciA8X2FD3CKo/edit?usp=sharing

Solution

  • You can't match the string "43" with the number 43. You need to convert the string to a number:

    =INDEX('Description Table'!A1:J23,MATCH(value(RIGHT(C2,2)),'Description Table'!A:A,0),MATCH(B2,'Description Table'!1:1,0))

    enter image description here