Is there a way to modify the range criteria within the Vlookup function to start at the n-th occurence of a text value?
Due to my industry, I am not allowed to use VBA.
What I am trying to do is have vlookup start when the text value "x" shows up for the second time in a column. For instance, there are two sets of data tables on one worksheet, the data sets are on top of each other and seperated by a common heading. The left most heading title is "Name". And, the tables depths are always changing. So a vlookup function that can start at the second occurance of "Name" will allow the function to work dynamically with the given data. The end range value is unimportant, because I can always put some random big number. Such as Ax:A1000, where "x" is the row number of the second occurence of "Name".
Any help on this would be great. Thanks a bunch.
Bookmarks