# 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:

• 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:

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↵

### 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.