Searching a list

K

Ken G

I want to have a data entry cell where a user can enter a Surname and either have the cursor jump to the first occurrence of that name in a list and be able to repeat if the found data is not the right one, OR to display the data which matches the input data plus display the data in adjacent columns

The stored data is not in alpha order, but in date entered order

Thanks
Ken G.
 
J

Jim Rech

About the only feature built into Excel that comes close to what you want is
Edit, Find. The shortcut is Ctrl+F.

--
Jim Rech
Excel MVP
|I want to have a data entry cell where a user can enter a Surname and
either have the cursor jump to the first occurrence of that name in a list
and be able to repeat if the found data is not the right one, OR to display
the data which matches the input data plus display the data in adjacent
columns.
|
| The stored data is not in alpha order, but in date entered order.
|
| Thanks,
| Ken G.
 
K

Ken G

Thanks Jim. I've done a bit more poking around by myself
and I've almost got what I want by using the "match"
function to locate the name in the list, then the "offset"
function to display the contents of the cell which is
offset by the number found in "match".

Ken G.
 
Top