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.

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

how would you use the vlookup function

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

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