HI,
1. Although this maybe easier in ACCESS, I cannot introduce this solution to
my client.
2. I have an EXCEL 2003 customer datasheet with columns from A to AS and up
to 5000 row entries, headers are similar to: Name, contact address, postcode,
tel no and so on. I am interested to find for a specific 'search' entry the
name, the company details, address, postcode or otherwise to automate invoice
writing.

I would like to enter -say either- a comp name, or a contact name or a
postcode (or the first few characters of those) in a cell on a new page to
find and display the relevant row entries in the datasheet, e.g. D4, H4, L4,
O4. or with other words I like to find with one of those entries the right
row entries or values. If a companyname has two contact persons then I may
want to search for the specific name and company as well. (So, OR or AND?)
If the position (from 1 to 4999) in column A would be returned I can always
use Vlookup to display me the relevant other entries. This represents my
unique customer idenitifier- sorted by customer name.

I tried INdex, Match, Sumproduct and also the lookups but didi not find the
correct solution- yet. Can someone help? THX in advance.