Dear Experts
plz let me know how to use the vlookup formula. (pictorial guide required)
thanks
Dear Experts
plz let me know how to use the vlookup formula. (pictorial guide required)
thanks
Please use Search option solution is here and check Magazines in which complete reply of your question
Visit here it has this formula
http://www.itdunya.com/showthread.ph...azana-Software
شکریہ بھائی جزاک اللہُ خیر
=VLOOKUP(lookup-value,table_array,index-column,range_lookup)
Step 1 Lookup value (what u want to search)
Step 2 Table Array (select the full table from where u want to search)
Step 3 Col Index Number (give column number in which colm is the value u need ( 2 or 3 or 4 etc)
lookuprange= put 0 for false,
false value mean exact match,,,
true value mean approximate value,
mostly we will use false for exact match
nice
iska work kya hai vlook up ka .... mujhy iski thek sy smjh nhi ayi
"Everybody in this world loves you for his own interest. Only ALLAH Loves you for your interest."
وی ۔۔۔سے مُراد ہوتی ہے
ورٹیکل
اور
lookup
کا مطلب ہےکہ تلاش کرنا
یعنی ایکسل میں ورٹیکلی ڈیٹا میں سے کچھ تلاش کرنا
Bookmarks