View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] halper@lgblp.com[_2_] is offline
external usenet poster
 
Posts: 9
Default Search a column and display a value

What I'm trying to do is have a formula search column B and then
display the values in column in the order they appear in column B. Is
there anyway to do this without using VBA?
(See Below)

Column A Column B
20 0
10 0
20
0
10


Thanks for your help.