Thread: VLOOKUP use column name not number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default VLOOKUP use column name not number
kathy wrote:
Is there a way to use VLOOKUP to search for a column name and return the
value in that column, rather search for a column number.


Use INDEX/MATCH. Look he

http://www.contextures.com/xlFunctio...ml#IndexMatch2
Reply With QuoteReply With Quote