informations search
 

I am interested in setting up a spread sheet that will search a second
and third sheet for information entered on sheet 1.

Is it possible to make excel do this.


--
DanBal
------------------------------------------------------------------------
DanBal's Profile: http://www.excelforum.com/member.php...o&userid=24079
View this thread: http://www.excelforum.com/showthread...hreadid=376838

Without more detail it sounds like a job for the vlookup function.


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376838

how would you use the vlookup function


--
DanBal
------------------------------------------------------------------------
DanBal's Profile: http://www.excelforum.com/member.php...o&userid=24079
View this thread: http://www.excelforum.com/showthread...hreadid=376838

I'd either read about it in excel's help or visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html


DanBal wrote:

how would you use the vlookup function

--
DanBal
------------------------------------------------------------------------
DanBal's Profile: http://www.excelforum.com/member.php...o&userid=24079
View this thread: http://www.excelforum.com/showthread...hreadid=376838

--

Dave Peterson

According to Excel Help. =VLOOKUP(value to search for,range to search
in,column number of value to return).


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=376838