Formula to Search one specific cell on another sheet.

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!
 
S

Suleman Peerzade

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
Formula Audit mode active in one column only; cannot kill. 2
Excel If a Cell Contains a Certain Text (From Another Table) 0
Finding a specific item between two sheets. 2
Compare values and place corresponding value in another sheet 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Balance Sheet Formula 5

Top