Excel formula

**masadijaz** · 14th July 2011, 10:42 AM

Assalam o alaikum dear all,

umeed hai ap log khairyat say hongay..

mujy excel mein aik formula chahye agar kisi ko ata ho to plz zaror share kijey g..

for example

Name Value

A 10
B 15
C 12

ab mein chahta ho k mein excel k aik column mein name likko to dosry column mein es ki value khud bakhud ajaye.

plz help me..

tnx

masadijaz

**kingirfan** · 14th July 2011, 11:32 AM

A/Salam App jis cell main value change karna chaty hain us cell main = sign type kar ky wo cell select kar dain
A1
B1
B1 cell main = type kar ky A1 type kar dain
app ka msla hal ho jay ga

**masadijaz** · 14th July 2011, 11:52 AM

mein dosry column mein name ki value ka bata raha ho = sign sy to pehly wala name ajata hai

**AtifRaza** · 14th July 2011, 02:22 PM

masadijaz said:

Assalam o alaikum dear all,

umeed hai ap log khairyat say hongay..

mujy excel mein aik formula chahye agar kisi ko ata ho to plz zaror share kijey g..

for example

Name Value

A 10
B 15
C 12

ab mein chahta ho k mein excel k aik column mein name likko to dosry column mein es ki value khud bakhud ajaye.

plz help me..

tnx

masadijaz

Easy hai VLOOKUP function se ho jaye ga!
EXCEL main aik example attach ki hai study krain!