Good morning:
This is an example what I am trying to achieve
Col-A Col-CO
Row 1: Name Address
Col-A Col-CO
Row 4: Name Search Address Search
Note: The names & address will be hidden below the respective search Col's.
I need to search by name (R-4 / CO-A) or by address (R-4 / CO-CO) and have
the corresponding name & address populate R-1 respectively. Please keep in
mind I am not a programmer.
Thank you in advance
John
Bernard Liengme - 26 Aug 2007 14:04 GMT
Explain: The names & address will be HIDDEN below the respective search
Col's.
I will be easy to put name in row 4 and locate corresponding address
or address in row 4 and find name
but not both without using 4 cells

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
> Good morning:
>
[quoted text clipped - 18 lines]
>
> John