| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Search one specific cell on another sheet.
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to Search one specific cell on another sheet.
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! What kind of result(s) are you expecting to see? Something in an adjacent column of "another sheet"? Would it work for you to autofilter the "another sheet"? |
|
#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! |
| Reply |
| 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 | |||
Hybrid Mode
