ExcelBanter - INDEX / MATCH Table Values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INDEX / MATCH Table Values (https://www.excelbanter.com/excel-discussion-misc-queries/449949-index-match-table-values.html)

SalientAnimal

INDEX / MATCH Table Values

Hi All,

I have a workbook with two sheets. Sheet 1 in my reference sheet (sheet with my table) and sheet 2 is my actual data_sheet. On my data_sheet I have a set of data similar to the file on dropbox:

https://www.dropbox.com/s/tzsu9iegzn...CH_Smaple.xlsx

All times are GMT +1. The time now is 05:22 PM.