View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jill_
 
Posts: n/a
Default look up formulas

I need a forumula that will give me mulitipal answers.

I have a constant value that is looking that value up in a chart and from
that constant value I need it to return the corresponding names.

ie #01001

Chart
01001 name 1
00001 name 2
11000 name 3
01001 name 4
01001 name 5

I am needing it to list NAME 1, NAME 4 and NAME 5

How do I write this?