Not sure how to title this, but here's what I want to do. I am looking up a value on one sheet, on a second sheet using the index and match functions (the value is to the left of the reference). The ranges are discontinuous, in that the referenced sheet has multiple tables, but the values I am looking up are in the same column. I can get it to look up consecutive rows in a table, but when I move to the next table, I have to enter the first row # by hand. I'm using the row # to make it easy on me, but I've noticed i can use any consecutive values on each table as long as the correct row # is referenced. I have many tables so I'd like to automate this to skip to the next table. I'm doing it with the row function but that can change if it makes it simpler. It's hard to explain here, but the attached workbook shows what I am trying to do.