Formula to Search one specific cell on another sheet.

  • Thread starter Thread starter Dan C.
  • Start date Start date
D

Dan C.

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!
 
Hi,

Please use lookup formulas for this.

=VLOOKUP(A1,End!B:B,1,FALSE)
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a new sheet from specific data in existing sheet 3
Count the columns from one sheet and paste it in another sheet 0
Finding a specific item between two sheets. 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Compare values and place corresponding value in another sheet 3
Excel If a Cell Contains a Certain Text (From Another Table) 0
Formula Audit mode active in one column only; cannot kill. 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0

Back
Top