Thread: Querying data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] paulquinlan100@hotmail.com is offline
external usenet poster
 
Posts: 3
Default Querying data

Hi

I have a spreadsheet that looks up to a seperate sheet of base data. I
want the user to be able to type in a number on the front sheet, which
then pulls out all records from the base table within 20% of that
number.

This is pretty easy to do in Access/SQL but is there a way of doing it
in excel?

Thanks for any suggestions.
Paul