| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Search one specific cell on another sheet.
Hi,
Please use lookup formulas for this. =VLOOKUP(A1,End!B:B,1,FALSE) -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Dan C." wrote: My problem is that I am trying to take a number in 1 cell from one sheet and search a whole column on another sheet. I also need it to be able to continue to search the same column on the other sheet even if I select a new cell. I cannot remember how to do this effectively but it would save so much time compared to using the find method and switiching from sheet to sheet. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search a cell for a specific number | Excel Worksheet Functions | |||
| Extract specific value using SEARCH FORMULA | Excel Worksheet Functions | |||
| Search for record with specific name in a cell | Excel Worksheet Functions | |||
| How do I search for specific text and sum the cell to the right? | Excel Worksheet Functions | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
![Suleman Peerzade[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
