|
|
|
|
||||
|
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. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
01-21-2010, 11:30 AM
|
#1 |
|
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 |
|
|
|
01-21-2010, 11:32 AM
|
#2 |
|
So Fucking Banned
Join Date: Apr 2004
Location: Texas
Posts: 190
|
give me a sec
 |
|
|
|
|
01-21-2010, 12:13 PM
|
#3 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
okay
 |
|
|
|
|
01-21-2010, 03:03 PM
|
#4 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
hmm i think he fell asleep
 |
|
|
|
|
01-21-2010, 03:06 PM
|
#5 |
|
Confirmed User
Join Date: May 2002
Location: European Union
Posts: 3,815
|
Hmmm, I think you're expecting a bit too much from GFY
|
|
|
|
|
01-21-2010, 03:08 PM
|
#6 |
|
So Fucking Banananananas
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 |
|
|
|
|
01-21-2010, 03:10 PM
|
#7 |
|
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?
|
|
|
|
|
01-21-2010, 03:13 PM
|
#8 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
taking screenshot, brb
|
|
|
|
|
01-21-2010, 03:17 PM
|
#9 |
|
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. |
|
|
|
|
01-21-2010, 04:56 PM
|
#10 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
bump for database being back up
|
|
|
|
|
01-21-2010, 07:46 PM
|
#11 |
|
Got MIDs?
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) |
|
|
|
|
01-21-2010, 09:46 PM
|
#12 |
|
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)
|
|
|
|
|
01-21-2010, 09:50 PM
|
#13 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
nevermind working, forgot the commas, thanx so much
|
|
|
|
|
01-22-2010, 12:20 AM
|
#14 | |
|
Too lazy to set a custom title
Join Date: Dec 2006
Posts: 23,400
|
Quote:
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 |
|
|
|
|
