Login

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
 
 Page 1 of 212Next 
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

Victoria Ogunsanya
Victoria Ogunsanya

Leveraging Blockchain Technology for Enhanced Data Security in Business Operations

Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...
Rianat Abbas
Rianat Abbas

Secure by Design: Why Security Shouldn't Be an Afterthought in Software Development

Building software products that solve actual customer concerns and generate business success is not an easy fit. Product executives battle strong competition, tight timelines, and high expectations, all while seeking to offer value. While success gives the opportunity to showcase approaches and frameworks, the reality is that building excellent pro...
Abuh Ibrahim Sani
Abuh Ibrahim Sani

Business Impact Analysis(BIA): Assessing the Potential Impact of a Cybersecurity Incident on Business Operations

Business Impact Analysis(BIA): Assessing the Potential Impact of a Cybersecurity Incident on Business Operations
In today’s highly interconnected society, businesses depend on technology even more than before. While offering opportunities for innovation and creativity, businesses are exposed to various cybersecurity threats that can disrupt operations, damage reputation, and result in substantial financial losses. It is crucial to carry out a comprehens...

 



Upcoming Live Webinars




 

brought to you by Modern Analyst Media LLC enabling practitioners & organizations to achieve their goals using:

Copyright 2006-2025 by Modern Analyst Media LLC