Excel. How to fill or copy data in cells automatically?

[nicholes]

Hi,

i want to fill (or copy) some specific data to be entered in particular cell for example....

(i am using 2007)

Whenever i bought an item i put date, price, name of the person, quality ,etc.and a specific or unique item number (can be x99,a33,any random thing).

and when i sell it i type items unique number now here i want some magic (by using that unique no) which automatically fill all the detail of that that item like name of the person, quality, date of bought, etc.


please give me detailed answer.

 

[Luke M]

Check out Chandoo's latest article:

http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/

 

[nicholes]

well thanks! it looks cool.. i hv not checked it up yet deeply since i am from india, it means i am now going to sleeeeeep(it is too late here to sleep for me). so will go through tomorrow.

 

[nicholes]

Hi, thanks for the reply i saw INDEX&MATCH functions and also vlookup, but i think i need something different let me explain again

First of all I don’t want to use different sheet for purchasing and selling items, I use one sheet only so

I want to copy only the content of a raw, in a different raw for example, I have a1 b1 c1 d1 e1 filled with (date, name of item, quality, price, a unique no) that is when I punches an item.


Now when I sell an item I type that unique no. in a cell here I want to copy some information that is filled in b1,c1,d1,etc, automatically. Right now I type it manually


In other words I want to copy the some content of a raw in different raw by typing only one unique word

 

[SirJB7]

Hi, nicholes!

Could you please upload a sample file? Refer to the first three green sticky topics at this forums main page for guidelines if needed.

Regards!

 

[nicholes]

i think index&match should work but i am no getting the formula(i am new in it)


so here is file


http://www.2shared.com/file/fdbeMfxz/nicholes.html


and here is the image


http://postimage.org/image/6vckcetl1/


here is what i want in it..


i use one sheet and devied it into two section(bought and sold)


i want> when i type unique no in sold section, the other fields(in sold section) should automatically be filled

 

[nicholes]

i think index&match should work but i am no getting the formula(i am new in it)


so here is test file


http://www.2shared.com/file/fdbeMfxz/nicholes.html

and here is the image

http://postimage.org/image/6vckcetl1/

here is what i want in it..


i use one sheet and devied it into two section(bought and sold)


i want> when i type unique no in sold section, the other fields(in sold section) should automatically be filled

 

[nicholes]

i think index&match should work but i am no getting the formula(i am new in it)


so here is test file

http://www.2shared.com/file/fdbeMfxz/nicholes.html

and here is the image

http://postimage.org/image/6vckcetl1/

here is what i want in it..


i use one sheet and devied it into two section(bought and sold)


i want> when i type unique no in sold section, the other fields(in sold section) should automatically be filled

 

[nicholes]

i think index&match should work but i am no getting the formula(i am new in it)


here is the image

here is what i want in it..


i use one sheet and devied it into two section(bought and sold)


i want> when i type unique no in sold section, the other fields(in sold section) should automatically be filled

 

[Faseeh]

Hi nicholes,


Enter these formulas in respective cells:

[pre]

J3 : You are entering data manually
K3 : =INDEX($A$2:$A$2,MATCH($J2,$F$2:$F$2,0),0)
L3 : =INDEX($D$2:$D$2,MATCH($J2,$F$2:$F$2,0),0)
M3 : =INDEX($H$2:$H$2,MATCH($J2,$F$2:$F$2,0),0)
N3 : =INDEX($C$2:$C$2,MATCH($J2,$F$2:$F$2,0),0)
O3 : =INDEX($G$2:$G$2,MATCH($J2,$F$2:$F$2,0),0)

[/pre]
..drag down and remember to adjust ranges as i worked it out with just one row.


Regards,

Faseeh

 

[nicholes]

it worked thanks to all specially faseeh


now i understand how index match works.


Thanks again