| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and search by column | Excel Discussion (Misc queries) | |||
| How do I print a Find-all search in Excel 2002? | Excel Discussion (Misc queries) | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
| how to use the search dialog box ? | New Users to Excel | |||
| can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions | |||
Linear Mode
