For reasons I cannot understand I have to use a COUNTIF function to lookup values in a range. This works just fine but I need to display a corresponding cell instead of TRUE or FALSE. I have used INDEX, MATCH, VLOOKUP, Power Pivot Relationships and this is the formula that does not produce an error. If I can get it to display a cell reference instead of TRUE or FALSE I can add another column to get the data to produce I need to see.
=COUNTIF('Archer Search Report'!H:AG,Sheet15!A2)>0
Any ideas to getting the cell reference instead of TRUE or FALSE?
Additional Info:
Essential I have two tables. Table1 has a current ID list and Table2 has a range of Legacy IDs. If an ID in Table1 matches any of the IDs in the range on Table2 there is a corresponding number which I need populate.
=COUNTIF('Archer Search Report'!H:AG,Sheet15!A2)>0
Any ideas to getting the cell reference instead of TRUE or FALSE?
Additional Info:
Essential I have two tables. Table1 has a current ID list and Table2 has a range of Legacy IDs. If an ID in Table1 matches any of the IDs in the range on Table2 there is a corresponding number which I need populate.