1. Rate list ka formula required hai???

2. pari gull said:
Ma screen shot kasy do .. Ma PC pa kam kr rahi hun ..

3. Shahbazjee7 said:
Rate list ka formula required hai???
Sir thori si information de den... apke madad koshesh karainge or InshaALLAH kardi jayegi

4. Junior Member
Last Online
7th June 2017 @ 05:05 PM
Join Date
07 Jun 2017
Age
71
Gender
Male
Posts
1
0
Credits
5
Thanked
0

## Solution

pari gull said:
Plz mja koi ASA farmula bta sakta a k ma bus city k nam lekho or us Ki value us k samny ay .. Plz any one help me....
=IF(B9="lahore",30,IF(B9="islamabad",49,IF(B9="kar achi",40))) B9 IS CITY FIELD ID

5. Senior Member+
Last Online
12th September 2017 @ 01:23 PM
Join Date
12 Jun 2017
Location
Karachi
Gender
Female
Posts
59
1
Credits
394
Thanked
2
Hey Pari,

You can use vlookup farmula here:

Syntax

The syntax for the VLOOKUP function in Microsoft Excel is:

=VLOOKUP( value, table, index_number, [approximate_match] )

Parameters or Arguments

value
The value to search for in the first column of the table.
table
Two or more columns of data that is sorted in ascending order.
index_number
The column number in table from which the matching value must be returned. The first column is 1.
approximate_match
Optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.

If you still can't understand it you can search the use of this formula in YouTube.

6. Senior Member+
Last Online
9th July 2018 @ 10:03 AM
Join Date
06 Jun 2017
Location
Age
23
Gender
Male
Posts
63
12
Credits
368
Thanked
2
je han ye possible hai

lookup k formula k zariye

7. WardaRiaz said:
Hey Pari,

You can use vlookup farmula here:

Syntax

The syntax for the VLOOKUP function in Microsoft Excel is:

=VLOOKUP( value, table, index_number, [approximate_match] )

Parameters or Arguments

value
The value to search for in the first column of the table.
table
Two or more columns of data that is sorted in ascending order.
index_number
The column number in table from which the matching value must be returned. The first column is 1.
approximate_match
Optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.

If you still can't understand it you can search the use of this formula in YouTube.
Well Explained

8. Junior Member
Last Online
6th February 2018 @ 10:36 AM
Join Date
17 Aug 2017
Location
Gender
Male
Posts
28
20
Credits
342
Thanked
3
yes madam ap screen shot dain shayed ma ap ke koi help kar don ma be excel use karta ho liken bohat kam

9. Member
Last Online
7th December 2018 @ 11:23 AM
Join Date
19 Oct 2017
Location
Multan
Gender
Male
Posts
60
8
Thanked
2
File with formula attached below....

Enjoy.........

10. Senior Member+
Last Online
9th February 2019 @ 01:04 AM
Join Date
11 Apr 2009
Age
39
Posts
60
9
Credits
214
Thanked
0
mere khayal se app ka kaam nahi ho ga kion k app ko kuch to khod se add karna ho ga or farmula b kafi bhara lagana pare ga jesa k malti ^>mto +34= wagera wala

11. Junior Member
Last Online
28th December 2017 @ 06:10 PM
Join Date
24 Jul 2016
Age
26
Gender
Male
Posts
1
0
Credits
417
Thanked
0

## USE VLOOKUP FORMULA

USE VLOOKUP FORMULA

12. see attached file

pari gull said:
Plz mja koi ASA farmula bta sakta a k ma bus city k nam lekho or us Ki value us k samny ay .. Plz any one help me....

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•