VLOOKUP

What Really vlookup do?

Vlookup searches a value in the list and return the corresponding values

Suppose you have a list of data Like  this

(Inventory Data)
Suppose We wish to Fetch the Product Description in Daily Sales
The General Syntax of vlookup is =vlookup(lookupvalue,tablearray,col_index_num,[range lookup])
Here is our case the formula look like this  

=VLOOKUP(E9,Inventory!B8:C18,2,FALSE)



Subscribe to: Posts (Atom)