View Single Post
  #53  
Old May 20th, 2010, 02:11 AM posted to microsoft.public.excel.worksheet.functions
G.[_2_]
external usenet poster
 
Posts: 1
Default How can I lookup when match has more than one value?

Hi I actually have another similar problem, can you help me?

Hi I actually have a similar problem. Could you help me: Basically. I want
to look up number 222222 in column A, and have it returns 3 values from
column B which are 666666, 777777, and 9999999 in 3 separate column. Please
help!


1....................A....................B
2..............123456...............1111111
3..............222222...............6666666
4..............222222...............7777777
5..............222222...............9999999
6..............444444...............8888888