Thread: Lookup formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CP CP is offline
external usenet poster
 
Posts: 64
Default Lookup formula

I am looking to see if excel can help with a form of query.

Sheet2 contains various data similar to:-
Code Description value (basicly a stock list)

Sheet1 has a Cell (A1) where I type any part of code or description and any
matching results from Sheet2 appear in rows A3 to A1000

I have failed upto now in figuring this one out - any help?