I have a huge dataset. Column A is categories. Column B is a id value. Column C is a result value.
eg
Cars 1001 5.345
Cars 1002 6.234
Cars 1004 0.445
Cars 1008 9.332
Dogs 1001 0.345
Dogs 1003 1.223
Food 1001 3.523
Food 1145 0.254
Food 2512 3.346
Table is sorted by Column A then Column B
there are close to 1000 categories and almost 1,000,000 rows total
I have another table with the same categories AND the number of rows down the list I want to report.
eg in second table Cars 3 means I want to find the result value in table 1 for the third row of Cars data. (Cars 1004 0.445 so 0.445 is the answer I want)
and Food 2 means I want to find the result value of the 2nd row of Food data (Food 1145 0.254 = 0.254)
Is there a formula/function that lets me locate that easily. So count down rows where column A = Cars and the report the result of row x?
Hope that made sense. Thanks
Bookmarks