Learn Excel & Advance Excel - Sk Excel Trick

Microsoft Office is a powerful service that helps you release your best ideas to get things done and visit associated on it is go.MS Office applications with new and enhanced features continually being added. It is Microsoft Excel spreadsheet platform that features calculation, graphic tools, pivot tables, and macro programming language support for programs commonly used in an office situation. There are various function of MS office in.

Thursday, September 10, 2020

VLOOKUP with MATCH Formula

 VLOOKUP WITH MATCH FORMULA 

It is VLOOKUP function, the column index argument is ordinarily hard-coded as a static number.  Still, you can also create a dynamic column index by using the MATCH function to locate the right column. This skill allows you to create a dynamic two-way lookup, matching on both rows and columns. It can also make a VLOOKUP formula more irrepressible: VLOOKUP can break when columns are inserted or removed from a table, but a formula with VLOOKUP + MATCH can continue to work correctly even changes are made to columns.


Syntax :- =VLOOKUP(lookup_value,table,MATCH(col_name,col_headers,0),0) Enter

Example  :- =VLOOKUP(P4,H5:M10,MATCH(P5,H4:M4,0),0) Enter


at
Labels:

2 comments:

  1. UnknownSeptember 12, 2020 at 11:24 AM

    Nice baa ho

    ReplyDelete
  2. shaleenFebruary 24, 2021 at 11:00 AM

    Thanks for sharing this. Very fruitful to find this kind of tactics for Excell. It will gonna help me out from beginning!!! Keep sharing

    ReplyDelete

if you have any doubt let me known will
give suggestion in this site

Thank you so much

Subscribe to: Post Comments (Atom)

https://www.youtube.com/channel/UC-ydS7go5OShxe0MIeUMwUg

How to use Goal Seek in Excel for What-If analysis #sk excel trick

 How to use Goal Seek in Excel for What-If analysis #sk excel trick What-If Analysis is one of the most powerful an Excel features and one o...

https://www.youtube.com/watch?v=FHsEvT-UpDA&t=6s