MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Record Search


Posted by Baudelaire Etienne on January 24, 2002 1:45 PM

How do I search for a record in an Excel database or list? I undertand how VLOOKUP allows you to look up the value in a field, but how do you look up an entire record in a list?

Thank you all for your anticipated contributions.


Posted by Richard S on January 24, 2002 2:29 PM

Autofiler?

You could perhaps use the Data|Filter|Autofilter oprion, then select the criteria for each filed that you are after. Is that what you want?
Richard
__________