VLOOKUP, HLOOKUP, MATCH,MIN MAX, COLUMN FORMULA #advanceexcel #excel #viral #youtube #excelexpert

VLOOKUP KA USE KAISE KARE HLOOKUP KA USE KAISE KARE MIN MAX KA USE AASAN TARIKA VALUE KO FIND KARNE KA TARIKA
VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
What is VLOOKUP step by step?
In the Formula Bar, type =VLOOKUP().
In the parentheses, enter your lookup value, followed by a comma. ...
Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
Enter column index number. ...
Enter the range lookup value, either TRUE or FALSE.
FOLLOW ME ON INSTAGRAM
https://www.instagram.com/thevickyedu/

Видео VLOOKUP, HLOOKUP, MATCH,MIN MAX, COLUMN FORMULA #advanceexcel #excel #viral #youtube #excelexpert канала vicky Tech Education