Need Microsoft Excel Help

[Sushant]

Here you go. I changed it to make it easier for you.
http://www.mediafire.com/?as6cv5ekaz5hcx5

Thanx Lock Down. I though Sushant could follow the hints and therefore left my sheet for him to design according to his choices. Yours will be of much help.

yes Lock Down Thanks Yours one is working fine.....can you please tell me now how to add more countries and more hosts in this file?

---------- Post added at 08:10 AM ---------- Previous post was at 08:10 AM ----------

I have just copied the formula upto the data in ColumnA. You have to copy the formula in the below cells. I think this is not the right place to discuss much on the subject. You contact me to my email address.

Added You iN Gmail Mate......PM me when you come online :-)

[jhantoojha]

Yes you can add it at Sheet2. You right click on Sheet1 tab below and Click on Unhide. It will unhide Sheet2. In Sheet2, add filehost in ColumnA and corresponding country in ColumnB. The formula has taken into consideration for 15 filehosts. If you like to add more filehosts, you will have to slightly change the formula. Suppose you are going to add 25 filehosts in total, Click on B1 in Sheet1. Go to the formula bar. You will see the formula as : ==IF(ISTEXT(A1),VLOOKUP(Sheet2!G1,Sheet2!A$1:B$15, 2,0),""). As you have decided to make provision for 25 filehosts, simply change B$15 to B$25 and click enter. Now copy the formula of B1 to below say upto B4000 or more.
Lock Down may suggest for his alternative.

[Sushant]

Yes you can add it at Sheet2. You right click on Sheet1 tab below and Click on Unhide. It will unhide Sheet2. In Sheet2, add filehost in ColumnA and corresponding country in ColumnB. The formula has taken into consideration for 15 filehosts. If you like to add more filehosts, you will have to slightly change the formula. Suppose you are going to add 25 filehosts in total, Click on B1 in Sheet1. Go to the formula bar. You will see the formula as : ==IF(ISTEXT(A1),VLOOKUP(Sheet2!G1,Sheet2!A$1:B$15, 2,0),""). As you have decided to make provision for 25 filehosts, simply change B$15 to B$25 and click enter. Now copy the formula of B1 to below say upto B4000 or more.
Lock Down may suggest for his alternative.

Thanks mate it is really helpful for me now.......and Thanks to Lock Down also...:-)

---------- Post added at 11:47 AM ---------- Previous post was at 10:40 AM ----------

Buddy i have one problem in it when i m adding shareflare and mediafire link then i m getting #N/A something this kind of error :-ss

[Lock Down]

You are welcome.

show me the cells you added on the second sheet that you are having problems with andthe link that gives #N/A

[Sushant]

You are welcome.

show me the cells you added on the second sheet that you are having problems with andthe link that gives #N/A

http://www.mediafire.com/?ajavi5xx33axcy8

Please download it.I have just added country and File Host in Sheet B and also changed Formula column B15 to B200

[jhantoojha]

There are few errors in your sheet. You have added country for BAYFILE whereas the host is Bayfiles. This results error. Again rapidshare/filepost sometime creates links as https instead of http which was not taken into consideration. Moreover, Uploaded.to creates links as ul.to/upoaded.to. But you have created country name for Uploaded.

I have redesigned the sheets into more simple way so that any future errors can easily be identified. Everything is in Sheet1 (Few columns to be kept as hidden) and Sheet2 for Host-Country list. All formulas have been copied upto row 8000. So you have to copy onwards when you have reached A8000.

http://www.filefactory.com/file/c3e06f6/n/TV.xlsx

Check it and give feedback.

[Lock Down]

http://www.mediafire.com/?c382cfb7dgbvq2w

There you go .. Had to modify one of the calculations..

[Sushant]

There are few errors in your sheet. You have added country for BAYFILE whereas the host is Bayfiles. This results error. Again rapidshare/filepost sometime creates links as https instead of http which was not taken into consideration. Moreover, Uploaded.to creates links as ul.to/upoaded.to. But you have created country name for Uploaded.

I have redesigned the sheets into more simple way so that any future errors can easily be identified. Everything is in Sheet1 (Few columns to be kept as hidden) and Sheet2 for Host-Country list. All formulas have been copied upto row 8000. So you have to copy onwards when you have reached A8000.

http://www.filefactory.com/file/c3e06f6/n/TV.xlsx

Check it and give feedback.

http://www.mediafire.com/?c382cfb7dgbvq2w

There you go .. Had to modify one of the calculations..

Thanks Guys.....But if i want to add more hosts what do i need to do?

Simply Add Hostname in Sheet 2's A Column and Country in B or do i need to make any other changes?

[jhantoojha]

The file I provided you is meant for 200 filehosts and that's enough, I think. If you need more, simply add host and country in Sheet2 and change the formula as suggested before.
Click on F1 in Sheet1. At formula bar, you see the formula as =IFERROR((VLOOKUP(E1,Sheet2!A$1:B$200,2,0)),""). Here B$200 means for 200 filehosts. So if you need for 300 filehosts, change 200 to 300 and hit enter. Now copy the formula at F1 to the end say F8000 or more.

[Lock Down]

I made it 8000 like in the original sheet I made so yes a & b on sheet2.

And you are welcome.