View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default HLOOKUP() to return heading cells

Cells A1:F1 consists of headings:
Class-I; Class-II; Class-III; Class-IV; Class-V; Class-VI;

Cells A2:F13 consists unit price of every Class during each of the 12 months.

I want to insert a formula in H2:H13 which shall consider the corresponding
Value in G2:G13, lookup in the respective cells of the same row in columns
A:F and return the EXACT relevant Class Heading from A1:F1.


--

Best Regards,
FARAZ A. QURESHI