View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] smatthewscpa@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to return column header contents when a cell in the column has a value

60120 60125 61065 61128 61140
411AMERICAN
1502CDW 437
3172FRANKLINS 263
7876STANDARD 286
7889STAPLES 1,640
30385VACO LLC 102,624

I'm trying to do an index/match function from another page in a workbook (pointing to this range of data). I would like to match from a cell on another page to column A....look across the row to the column with a value 0 and return the column header.

For example, 7889STAPLES would return the result "61140"; 1502CDW would return "61065"; and so on.

Any ideas?