informations search

[DanBal]

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.

 

[cwinters]

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

 

[DanBal]

how would you use the vlookup functio

 

[Dave Peterson]

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

 

[MrShorty]

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