Downloads 15 - Excel Formulas Bible
This is one single document which contains close to 100 formulas dealing with various situations. Useful for Intermediate and Advanced users.
Download it from Excel - Formulas Bible
By eforexcel|2017-04-28T13:13:47+00:00Saturday, May 06th, 2017|Categories: Downloads|Tags: Cube, Date, Engineering, Financial, Formulas, Functions, Information, LOOKUP, Mathematics, maths, Statistical, text, time|0 Comments
This is one single document which contains close to 100 formulas dealing with various situations. Useful for Intermediate and Advanced users.
Download it from Excel - Formulas Bible
By eforexcel|2017-03-26T08:51:47+00:00Saturday, April 08th, 2017|Categories: Tips and Tricks|Tags: Column, Column Index Number, Columns, Count, COUNTA, HLOOKUP, INDEX, LOOKUP, MATCH, VLOOKUP|0 Comments
One of the negative points which gets attributed to VLOOKUP is that whenever a column is added / inserted within the range of VLOOKUP, the column index number doesn't change. Hence, it gives wrong result. Let's consider below dataset and for a given Emp ID, I need gender of that person. Hence, for Emp ID, 754761, the formula would be =VLOOKUP(754761,$A:$G,6,0) and answer would be F. Now, let's delete a column and now the answer would be lelia.vang@gmail.com as column_index_number is still 6. Now, add a column and the answer would be Vang as column_index_number is still 6.
By eforexcel|2015-09-17T18:59:12+00:00Saturday, September 12th, 2015|Categories: Articles|Tags: Find, INSTR, INSTRREV, LOOKUP, MID, Reverse, SEARCH|0 Comments
Excel doesn't offer any function for reverse FIND / SEARCH & MID function. VBA does offer a function INSTRREV but this article is for non-VBA folks or folks who do not want to use VBA in their spreadsheet.
Hence, the only option before us is to build them through formulas. Let's build a reverse FIND / SEARCH function.
Note - There are two differences between FIND and SEARCH which you must make a note of.
By eforexcel|2016-01-05T17:35:09+00:00Saturday, May 30th, 2015|Categories: Quizzes|Tags: Assessment, CHOOSE, Exam, HLOOKUP, LOOKUP, Quiz, Test, VLOOKUP|3 Comments
0 of 10 questions completed
Questions:
The thirteenth quiz in the series to test your knowledge on Lookups in Excel. After you hit Finish Quiz, you can click on View Questions to compare your answers to correct answers.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
What would be the answer for
=LOOKUP(48,{0,40,70,80,90},{"F","D","C","B","A"})
What would be the answer for
=LOOKUP(1000,{0,40,70,80,90},{"F","D","C","B","A"})
What would be the answer for
=CHOOSE(3,0,8,11,3,12,56,9)
The syntax of VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). If range_lookup is either TRUE or omitted, the first column of table_array must be sorted in ascending order.