Combining Vlookup With Column function in excel

• Report this article

Soumalya Khan

Soumalya Khan

Software Trainer

Published Jan 1, 2024

+ Follow

In VlookUp extracting the data from a particular column there is a hindrance of modifying the formula by changing the column index number which can be overcome by combining it with VLOOKUP to make it more dynamic. You can take a look at this example to find out more.

To view or add a comment, sign in

More articles by Soumalya Khan

• My Youtube contents

  Apr 8, 2024

  My Youtube contents

  Its to my privileges' that i have completed another video guide on programming. The full list to my videos is here in…

  1
• JShell in java which was introduced from Java 9

  Jan 1, 2024

  JShell in java which was introduced from Java 9

  Jshell in java was introduced from Java 9 onwards and here is a small demostration on how you can use JShell in java…

  1
• Varargs feature of Java5

  Dec 9, 2023

  Varargs feature of Java5

  We all know that a method when takes in parameter we need to declare before hand the number and type of parameter it…

  1
• Create New Building Block in ms word

  Nov 29, 2023

  Create New Building Block in ms word

  Macros in general speed up the working of MS Word by playing some pre recorded formatted text in your ms word…

  1
• Migrating data from MYSQL Workbench 8.0 to Excel

  Nov 25, 2023

  Migrating data from MYSQL Workbench 8.0 to Excel

  Hello all. I have made a short video tutorial to demonstrate how easily you can export data from mysql workbench to a…

  1
• End of Flash Era

  Oct 27, 2023

  End of Flash Era

  As i was pondering over the change in technology, i thought of drawing attention to the fact that modern browsers…

  1
• Writing Articles

  Sep 19, 2023

  Writing Articles

  Hello all..

  1
• Java 8 Stream Api and Filter function

  Sep 18, 2023

  Java 8 Stream Api and Filter function

  Hello all. In this practice video i have shown some collection features like the use of Arrays.

  2
• Repeat table Headers in MS Word

  Sep 10, 2023

  Repeat table Headers in MS Word

  Hello !!! I made a summarized video on how to repeat table headers in MS Word. Follow along the video to know more of…

  1
• Subtotal function in excel to make calculations in excel based on the visible cells

  Sep 10, 2023

  Subtotal function in excel to make calculations in excel based on the visible cells

  Hi !! Suppose i have a spreadsheet within hundreds of data out of which some rows are hidden. Now if we apply autosum…

  3

Show more

See all articles