General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
lookup data in excel
I'm trying to craft a query in ms excel 2003 that will look return the values. What I want to accomplish is type in data and the output would be the one before it and the one after it.
For example, if i have the following info:
a1 = aaa
a2 = aba
a3 = aca
a4 = ada
...
I want to be able to type in an input box (or other) 'aca' and the output will be aba & ada.
I'm sure that this is possible and i have been working with Vlookup, but i just can't seem to get it to work.
Any help would be appreciated.
tk