Quick Links: Articles MA Blog Community Blog Templates Books BA Humor Events Jobs Interview Questions RSS Feeds
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?
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
Vlookup can deal with the whole workbook, ctrl+f only works for one worksheet
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
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
Craig Brown -General Analysis -Project & Personnel Management View Posts View Expert's Biography
Guy Beauchamp -Data Analysis & Modeling -Structured Systems Analysis View Posts View Expert's Biography
Jarett Hailes -Agile Methods (SCRUM) View Posts View Expert's Biography
Perry McLeod -UML Modeling -Project & Personnel Management View Posts View Expert's Biography
Sandy Lambert -General Analysis -BPMN Modeling View Posts View Expert's Biography
The Community Expert is just one way that Project Members volunteer their time to help the Modern Analyst Community. Want to become a Community Expert in one of the following areas? Submit yourself to be selected as a Project Member.
Available topics include:
Advertising Opportunities | Contact Us