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
brought to you by enabling practitioners & organizations to achieve their goals using:
enabling practitioners & organizations to achieve their goals using: