Linking Cells Based on Condtion

[Mohandas]

I have Fill which has Packs and Brands

Some of the packs are sub totalled is brands


There is another sheets only Brands


I want link the Brand from the Packs ans Brands


To manually link it is taking take


Do u have any Formula


Please find the sample file


http://www16.zippyshare.com/v/18586515/file.html

 

[kaushik03]

Hi Mohandas,


Welcome to this forum and we glad to have you here.


Unfortunately I am not able to download your sample file from the link you have posted. Can you plz upload it here:


http://www.speedyshare.com/


Kaushik

 

[SirJB7]

Hi, Mohandas!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


I've downloaded your file but I can't get what you actually want to do. Would you please elaborate a bit more and post a manual example (indicating input and output cells with its desired values)? Thank you.


Regards!

 

[Mohandas]

http://speedy.sh/8G3P2/AP1-Reco-Dec-12.rar


There are two sheets called brand recon and brand i need to get details from RDBN, CLosing, Opening from for thier respective brands i'e You can refer my brand sheet you will understand

 

[SirJB7]

Hi, Mohandas!

Sorry, but I still don't understand your requirements. Could you describe which data you want to be returned and which are the source and target? E.g., in sheet XXX column YYY I want the related column ZZZ from sheet WWW.

Regards!

 

[Mohandas]

For example in Brand Recon Sheet for the B column 4 Row that data i should get is from Opening Sheet AM Column 98 Row


I think you will understand


Mohandas

 

[SirJB7]

Hi, Mohandas!


Now I got it.


Try this:

=BUSCARV(A4;OPENING!B:BZ;COLUMNA(AM1)-1;FALSO) -----> in english: =VLOOKUP(A4,OPENING!B:BZ,COLUMN(AM1)-1,FALSE)

or this:

=INDICE(OPENING!A:BZ;COINCIDIR(A4;OPENING!B:B;0);COLUMNA(AM1)) -----> in english: =INDEX(OPENING!A:BZ,MATCH(A4,OPENING!B:B,0),COLUMN(AM1))


Regards!