View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
advanced novice advanced novice is offline
external usenet poster
 
Posts: 1
Default Finding a value or the one next to it in a range NOT array

Picture data in a phone book with 5 columns of names and numbers 10 cols
total. I need a function that will look up the name and return the number
that will work if I don't know in advance which column the name will be in.
(they aren't in alpha order). Vlookup and match presume I know which column I
am dealing with. Help this has taken many unprofitable hours from my life.