Learn Excel VLOOKUP with Multiple sheets | Hindi

Learn Excel VLOOKUP with Multiple sheets | Hindi

Learn Excel VLOOKUP with Multiple sheets | Hindi\rbr\rbr\rbrVLOOKUP (lookupvalue, tablearray, colindexnum, [rangelookup])\rbr\rbrlookupvalue (required)\rbr\rbrThe value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array\rbr\rbr .tablearray (required)\rbr\rbrThe range of cells in which the VLOOKUP will search for the lookupvalue and the return value.\rbr\rbrcolindexnum (required)\rbr\rbrThe column number (starting with 1 for the left-most column of table-array) that contains the return value.\rbr\rbrrangelookup (optional)\rbr\rbrA logical value that specifies whether you want VLOOKUP to find an ex match or an approximate match:\rbr\rbrTRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you dont specify one.\rbr\rbrFALSE searches for the ex value in the first column.


User: Kiki

Views: 22

Uploaded: 2017-10-04

Duration: 08:44

Your Page Title