help about excel formula....?

[ihtesham_ulfat]

dear mebers..

main nay aik file banani hai idea k ly ...>>> see picture...



ab mian is main mention feature add kerna chahta hoon kesy keroonga
kia aap meri is silsaly mian koi help ker skengay?

[Mubashir Aziz]

Aap vlookup use karain .....


=VLOOKUP(C9,$J$9:$K$18,2,FALSE)

= VLOOKUP(Cell jo aap select akr rahay hain , Range Yaani key Price List , Column Number (iss case main aap 2 no. column ko pick karain gay, False "yah iss liye kay agar itme na milay to error nah day)

Agar aab bhi samjh nay aaye to vlookup ka syntax daikh lain ... ya mujhay batain ...



Agar price list dostri sheet par daina chahtay hain to ussay naam daina hoga ..... Insert --> Name ---> Define , aab range select karain aur issay "PriceList" ka naam day dain .... aab vlookup ka formula yah hoga ...

=VLOOKUP(C9,PriceList,2,FALSE)