Hi all, I have some experience with Excel, but I am stumped with creating a
search function that is easy for my boss to use.

I need to make the "Advanced Find" Function very simply. I tried to make it
as easy as possible for my boss by inserting instructions next to the spot
where he types the name he needs to find records for between the **, but he
still doesn't get it. Can someone help me make an easy find function for my
boss?

We have a worksheet with many different companies, one for each row. We
want to be able to search by people's names, which may be in multiple columns
and/or multiple rows, and have all the company names associated with the
person come up.

How can I make this even easier for my boss?

Thank you for any help!
--
LegalPC

Hello LegalPC,

Sounds like you need a Vlookup, take a look at this link for more
details

http://www.contextures.com/xlFunctions02.html

oldchippy ;)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569180

I don't think this will work because I have a bouple of dozen possible
columns the name could be in (and it could be in each column). Could you
clarify this for me?
--
LegalPC


"oldchippy" wrote:


Hello LegalPC,

Sounds like you need a Vlookup, take a look at this link for more
details

http://www.contextures.com/xlFunctions02.html

oldchippy ;)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569180