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!

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"?

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!