help for formula

[81.kamlesh]

dera sir
if I put RCC100 into cell A1. Then in cell B1, I want it to
automatically say any name

like

rcc100 kamlesh

pls help

 

[Joe4]

Welcome to the Board!

Where is the name coming from?
Is there a list to choose from somewhere on your spreadsheet?

 

[81.kamlesh]

Welcome to the Board!

Where is the name coming from?
Is there a list to choose from somewhere on your spreadsheet?

if i put cell a1 & display B1

 

[Joe4]

No, I was asking where the name "kamlesh" is coming from. Maybe you are just hard-coding it right in the formula? If so, then just enter this in cell B1:

= A1 & " kamlesh"

 

[81.kamlesh]

No, I was asking where the name "kamlesh" is coming from. Maybe you are just hard-coding it right in the formula? If so, then just enter this in cell B1:

= A1 & " kamlesh"

no i mean i put in cell a1 rcc100 then display in cell b1 only name ramesh & c1 his post
please help

for example

A1 B1 c1
rcc100 ramesh manager
rcc101 jayesh excutive
rcc103 rajesh excutive

 

[Joe4]

The reason why you are not getting the answer you want is because it appears that you question is incomplete and lacking in important details.

If you are not hard coding the name in cell B1, where is this information coming from?
Is it being looked up from some list somewhere?
Where is that list?
How is it structured?
What about C1? Where is that information coming from?

 

[VoG]

Perhaps you want VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[81.kamlesh]

dear sir

i want to make my offic staff attendece in excel sheet

i am taking daily attendance my staff

so please help me

for example

i have 100 employees

i want to create a perticuler code for display my employees name in column b in cell b2

if i type RCC100 in colomn a in cell a1 so i want display employee name & there post

2 ) if i type RCC101 in column 1 in cell a2 so display another name column b in cell b2 & there postion in column c in cell c1

, but do not repeat already filled name

 

[Joe4]

I really don't know how to help me when you don't answer the questions I am asking you.

Are you wanting to create a lookup list, so that when you type in a certain value, it looks up that value in that pre-existing list your created?

If so, it sounds like VoG's response will do what you want. Take a look at the link he provided. Also, if you look in Excel's help files, you will find detailed explanation and examples on the VLOOKUP function.

 

[81.kamlesh]

If cell C2 has the text RCC100 in it, then cell D2 must automatically have the NAME (ANY NAME) inserted ( AS I GIVEN THE NAME )
If cell C3 has the text RCC101 in it, then cell D3 must automatically have the NAME (ANY NAME) inserted, AS I FEED