mujhay aik aisa formula chahye k agar main excell ki sheet1 k cell (a1) pay kuch likhun to sheet2 k cell (b2) pay wohi chize khud ajaye kisi ko is ka formula pata hoto plz mujay bta day
mujhay aik aisa formula chahye k agar main excell ki sheet1 k cell (a1) pay kuch likhun to sheet2 k cell (b2) pay wohi chize khud ajaye kisi ko is ka formula pata hoto plz mujay bta day
Ap aisa karien ke sheet2 ke cell b2 pe jaien aur wahan = type karien us ke bad ap kuch kiye bina sheet1 pe aien aur cell a1 pe click karien.
Bus ho gaya.
Ab ap koi bhi formula jo sheet1 ke cell a1 mein apply karien gai to us ka answer Sheet1 mein to aye ga sath sath sheet2 ke cell b2 mein bhi aye ga.
Umeed hai ke ap ko samjh agaya ho ga...
thnks aap nay mayri problem solve kerdi.
acha aik or prob bhi hai
for example
Biscuit =120
general =180
milk=280
sugar=290
ub main chahta hun k agar main sheet1 k cell(a1) main general type kerun to sheet1 k a3) main khud 180 likha aye
milk likhun to 280 likha aye
ye rate list excell ki sheet3 main write hai
OK Friend ... aap sample sheet attached kar dain .... solution mil jay ga .....
file attach kaisay kertay hain is main
im new user
yeh rate list hai jo k sheet3 mai hai
Biscuit =120
general =180
milk=280
sugar=290
ub main chahta hun k agar main sheet1 k cell(a1) main general type kerun to sheet1 k a3) main khud 180 likha aye
milk likhun to 280 likha aye
plz aysay hi bta dain
YAH LO DOOST SOLUTION ... ummed karta hoon kah yah helpful ho ga ...
=VLOOKUP(A1,'Price Table'!A1:B27,2,FALSE)
kindly sir is formula ko define kerdain
kyoun k agar main is main catagory bhi add kr dun to
yani
Description catagory weight Price Amount
Biscuit half roll 1 kg 120 Formula required
General family pac k 2 180 Formula required
Milk half roll 3 280 Formula required
Sugar family pack 4 290
sugar half pack 4 120
Last edited by lvdeeds; 18th March 2009 at 04:37 PM.
agar aap ko ye na samagh aye to main ap apna email day diye ga main us pay mail kr dunga
=VLOOKUP(A1,'Price Table'!A1:B27,2,FALSE)
iss main A1 to cell hain jiss ko aap range ('Price Table'!A1:B27)main dhoond rahay hain .....
'Price Table'!A1:B27 : Price Table Sath wali sheet ka naam hay aur A1:B27 iss key range hay ...
2, iss ka matlab hay kah oper di gai range main say 2nd column main say value select kar kay day ......
ap sheet2 k cell b2 par ya formula laago
=sum(sheet1!a1) ap ka Kam ho jaye ga.
kindly sir Ap mughay apna email address day dain main file puri file us pay ap ko send ker dunga us k hissab say ap formula put ker dye ga plz.
thanks for helping me mubashir aziz
Ok
Last edited by Mubashir Aziz; 19th March 2009 at 12:43 PM.
Bookmarks