View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nadine nadine is offline
external usenet poster
 
Posts: 216
Default Index, Match help

I need help with an index, match formula.

Worksheet 1 has 8 columns. In ColA is the name, Col 4 is the associated
cost center.
Worksheet 2 needs to find the cost center based on the name in ColE.
I could use a vlookup but the Index Match takes up less space when saved. I
am using Excel 2003. Thanks.