Return Header

  • Thread starter Thread starter Riki713
  • Start date Start date
R

Riki713

I have two sheets (sheet 1 & sheet 2), the first has a table (from A1:BR86)
with fund names at the top, region numbers on the side and sales numbers
inside the table, the other sheet has one of the regions sales numbers, On
the second sheet I need a formula that will match each sales number (in a
list from A1:A25) from the second sheet to that same number within the table
on the first sheet, then tell me what Fund name (column header) that sales
number falls under.
 
On your second sheet use this formula in B1 then copy it down to B25:
=INDEX(Sheet1!$A$1:$BR$86,$1,MATCH($A1,Sheet1!$A$1:$BR$56))
 
Back
Top