Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Excel question, domain name helper :) Excel question, domain name helper :)
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 01-21-2010, 11:30 AM   #1
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
Excel question, domain name helper :)
Can anyone help me with this excel command? I have a list of about 50 domains that are soon to expire in Sheet 1 column A, and my domain parking stats in Sheet 2 which display the domain name in Column A, Revenue Column B, Views Column C, and Clicks Column D. Rather than use the find command individually which I have been doing for the last 5 years, can I just match it up,

Basically in sheet 1 column B it would say:
If sheet 1 column a = sheet 2 column A, sheet1 column B = sheet 2 column B
etc

Hope someone can help
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 11:32 AM   #2
security_man
So Fucking Banned
 
Join Date: Apr 2004
Location: Texas
Posts: 190
give me a sec
security_man is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 12:13 PM   #3
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
okay
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 03:03 PM   #4
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
hmm i think he fell asleep
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 03:06 PM   #5
hjnet
Confirmed User
 
Join Date: May 2002
Location: European Union
Posts: 3,815
Hmmm, I think you're expecting a bit too much from GFY
hjnet is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 03:08 PM   #6
96ukssob
So Fucking Banananananas
 
96ukssob's Avatar
 
Industry Role:
Join Date: Mar 2003
Location: If I was in your ass you'd know it
Posts: 12,991
are you trying to do a vlookup? you can probably just do it with "if" statements, but i dont understand that you are doing

such as "if(sheet2a1=sheet1a1,b1," ") and it will display a blank or the value if they match
__________________
Email: Clicky on Me
96ukssob is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 03:10 PM   #7
Jarmusch
 
 
Industry Role:
Join Date: May 2003
Posts: 12,464
Why do you want to display the contents of sheet 2 column B on sheet 1 column B?
Jarmusch is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 03:13 PM   #8
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
taking screenshot, brb
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 03:17 PM   #9
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001


as you can see i have my domains i need to renew in sheet 1 and all my stats for over 1000 domains in sheet 2, i want to match them up and display the stats in sheet 1.
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 04:56 PM   #10
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
bump for database being back up
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 07:46 PM   #11
Brat
Got MIDs?
 
Brat's Avatar
 
Industry Role:
Join Date: Jan 2003
Location: Montreal
Posts: 1,545
Not sure if I understood correctly but if you want to match Column A in sheet 1 to Column A in sheet 2 and display Column B in sheet 2 in Column B is sheet 1 then this should work:

=vlookup(highlight A2 in sheet 1, highlight all of columns A & B in sheet 2, 2, FALSE)
Brat is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 09:46 PM   #12
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
yes thats exactly what i want to do. tried it but doesn't seem to work, returns N/A.

Code:
=VLOOKUP('Sheet 2'!A1:B1741, 2, FALSE)
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-21-2010, 09:50 PM   #13
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
nevermind working, forgot the commas, thanx so much
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-22-2010, 12:20 AM   #14
Iron Fist
Too lazy to set a custom title
 
Join Date: Dec 2006
Posts: 23,400
Quote:
Originally Posted by mkx View Post


as you can see i have my domains i need to renew in sheet 1 and all my stats for over 1000 domains in sheet 2, i want to match them up and display the stats in sheet 1.
That is definately a VLOOKUP then....

In cell B2 put this formula:

=VLOOKUP(A2,'Sheet 2'!$A:$E,2,FALSE)

and copy it all the way down....

In cell C2 put this formula:

=VLOOKUP(A2,'Sheet 2'!$A:$E,3,FALSE)

In cell D2 put this formula:

=VLOOKUP(A2,'Sheet 2'!$A:$E,4,FALSE)

That should do it...
__________________
i like waffles
Last edited by Iron Fist; 01-22-2010 at 12:23 AM..
Iron Fist is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Excel question, domain name helper :) Excel question, domain name helper :)
« Previous Thread | Next Thread »

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.