Hi,
I have an index and match formula written below which pulls the part description from column B on sheet1 by matching the location column in column A on sheet2 and column F on sheet1. This works fine but sometimes the same part may have multiple locations so I'd like it to look in column F, G and H to pull the description. Hope this makes sense, I have put the current formula below which only looks in column F and I have also attached a test spreadsheet
=INDEX(sheet1!B2:B9999,MATCH(sheet2!A2,sheet1!F2:F9999,0))
Regards
Bookmarks