How to use vlookup in excel 2007 with example

Learn: Vlookup to Find the Debtors Ageing Analysis in Excel

Debtors matlab – Jinse aapko Paise lene hai

In Simple Terms:

Kaafi saare Customers ko aapne, apni Company k Products beche hoge Credit pe.

Bohot log Delay kar dete hai Paise dene mai.

As a Person, jo aisi chiz pe Control rakhna chahe ki,kitne log aise hai jisne bohot dino(days) se Paise nahi diye hai,

kitne log aise hai jisne bohot dino(days) se Paise nahi diye hai, Mujhe unka Ek Report banake do.

Mene dekha hai ki, kaafi logo ko aise Report pasand hai, jo ye bata sake ki:Report

  • 91-180 Days → Kitne aise log hai jinhone Payment nahi kia hai?
  • 0-30 Days → Kitne aise log hai jinhone Payment nahi kia hai?
  • 46-90 Days → Kitne aise log hai jinhone Payment nahi kia hai?
  • >180 Days → Kitne aise log hai jinhone Payment nahi kia hai?
  • 46-90 Days → Kitne aise log hai jinhone Payment nahi kia hai?

Aap dekhte ho ki 80% waale Debtors>180 Days waale Category mai aate hai, tab Chinta ki baat hai.

Toh ye madat karega aapko sahi samay par unko Follow up karke unse Paise lene k liye:

Par Sawal ye hai ki, aap ye Report banaoge kaise?

Kum se kum samay mai, simple tarike se, satik Report banane ka tarika aapko milega Vlookup mai:

Refer : Vlookup with True for Better Unserstanding

Humara Usme 3 Conditions tha:

  1. Slab Based Non-Continuous Values
  2. At least, Onwards, Not Less Than, >=
  3. Ascending Order

Mai isko Numbers mai Convert kar leta hu:Conditions-Convert in Numbers

Ye ⇑Pool bananeka mehnat hai 1 baar, agar ye ban gaya.

Dosto ab faida mai dikhata hu:

  1. Type ⇒ {=VLOOKUP}
  2. Lookup Value → Select 122(C6 Cell) ⇒ {=VLOOKUP(C6,}
  3. Table Array → Select Pool Table(G5:H9 Cell) ⇒ {=VLOOKUP(C6,G5:H9}
  4. Press F4 → Taaki Table niche khiske nahi ⇒ {=Vlookup(C6,$G$5:$H$9,}
  5. Column Index No. → 2nd Column(2) ⇒ {=Vlookup(C6,$G$5:$H$9,2,}
  6. Range Lookup → True/1(Approximate Match) ⇒ {=Vlookup(C6,$G$5:$H$9,2,1}
    (Note: True/1 tab use kare jab aapke pass 3 Conditions ho jo mene uppar bataye hai)
  7. Press ENTER↵

Waah bhaiya, Answer aagya 122⇒91-80

Ye Calculate karta hai, dekhta hai ki:

  • 122 → Kya ye 91 se jyada hai? ⇒ YES
  • 122 → 181 se jyada hai? ⇒ NO

Issiliye, Vlookup with True ne Answer nikal k bahar kia ⇒ 91-180.

Toh dosto, ye tha kamal Vlookup with True ka.

Me chahuga ki aap ye Video dekhe, qki iske bohot saare faide hai:

  • Unme se 1 ye hai ki aap Report bana sakte ho Debtors Ageing k uppar.

Toh dosto, aise bohot saare Tricks milege humare Website par:

how to use vlookup in excel 2007