Help need....

[bruness]

Hi.
Fisrt, sorry for my poor English!!!

I have a problem with a function in a excel formula.

What i have is this:
I'm building a excel Sheet with my DIVX movies and DVD collection.
I have more divx than DVD, what i'm looking is this:
I have my divx movies in worksheet 1 and DVD list in worksheet 2, and i
what to search im divx movie if the movie that i going to ADD in DVD
already exist in my divx list, if so, then, it fill some cels with the
"data" that is in divx list.


Se the xls and please help me

Attachment filename: movie_list.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=424024

 

[Frank Kabel]

Hi
in your second worksheet in cell G17 enter the following:
=IF(ISNA(VLOOKUP($F17,'Sheet1'!$F$2:$N$999,COLUMN()-5,0)),"",VLOOKUP($F
17,'Sheet1'!$F$2:$N$999,COLUMN()-5,0))
copy this for cells H17:N17 and all rows

HTH
Frank

 

[bruness]

Hi Frank
Thanks a lot ;