Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  What is the differenec between vlookup and Ctrl+F?
Previous Previous
 
Next Next
New Post 1/21/2011 7:55 AM
User is offline BizAnalyst
1 posts
No Ranking


What is the differenec between vlookup and Ctrl+F? 

I did a quick glance over and all vlookup seems to do is report the finding of a value or it's adjacent cell..

Or, is this only useful because you cannot use Ctrl+F between multiple workbooks?

 
New Post 1/24/2011 6:12 PM
User is offline KJ
243 posts
6th Level Poster


Re: What is the differenec between vlookup and Ctrl+F? 

Welcome BizAnalyst79

vLookup is when you writing macros and manipulating formulae. Ctr+F is when you looking (Find and Replace), which can be used to search in all workbooks.

Checkout Excel Help!

warm regards,

K

 
New Post 3/21/2011 8:27 PM
User is offline John
1 posts
No Ranking


Re: What is the differenec between vlookup and Ctrl+F? 

Vlookup can deal with the whole workbook, ctrl+f only works for one worksheet

 
New Post 3/22/2011 2:47 AM
User is offline shijudaniel
1 posts
No Ranking


Re: What is the differenec between vlookup and Ctrl+F? 

Ctrl+F for single value search, where vlookup can work on a range of values.

 

ex: vlookup(column_to_search,range_of_data_to_search_and_compare,2,FALSE)

vlookup(a2,$i$2:$j$1000,2,false)

 

regards

 

Shiju

 
New Post 5/22/2013 1:18 PM
User is offline Christian1977
9 posts
10th Level Poster


Re: What is the differenec between vlookup and Ctrl+F? 

Hi,

Ctrl+F need to find a value on the table. No requirements.

Vlookup is a function and there are some rules to do it. If you have the same field in two tables you can create a unique table with the fields from both tables. 

Business Analyst Milano - Christian

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  What is the differenec between vlookup and Ctrl+F?

Community Blog - Latest Posts

Fabricio Laguna talks Business Analysis and AI
I recently connected with Fabricio Laguna, aka The Brazilian BA. Fabricio is a passionate and pioneering business analyst from Brazil. During our conversation, we had a thought-provoking discussion on how artificial intelligence stands to shape the field of business analysis in the years ahead. While AI promises to transform many aspects of busines...
Business Architecture, Ontology and More with Terry Roach
It's been a privilege meeting Terry Roach, a visionary in the field of enterprise architecture and business architecture. Terry's insights into the evolution of business models, the importance of ontology in architecture, and the potential of AI to shape our future were not only thought-provoking but also a reflection of his extensive exper...
Today I had the pleasure of chatting to Jignesh Jamnadas, Chief Operations Officer at Mosaic, about his Blueprints for Success. As a Senior Finance and Operations Executive, Jigs (as he is known to many) has a holistic understanding of all facets of business and a flair for managing both people and processes. Having worked with Jigs, I was struc...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC