This formula helps to pull required data from entire data.
For example: In sales data if I want to pull
Salesperson Name for specific deals vlookup can be used.
=Vlookup(lookupvalue, tablerange,col index,range lookup)
Lookup Value= In above example Lookup value is deal number.
Table range= Range will start from column with deal details and end with column with salespersons detail.
Col index= Column number of salesperson column in your range.
Range lookup= Keep always "0". This means exactly same
No comments:
Post a Comment