Excel question, domain name helper :)

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mkx
    Confirmed User
    • Nov 2003
    • 4001
    #1

    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
    Tags: None
    • security_man
      So Fucking Banned
      • Apr 2004
      • 190
      #2
      give me a sec

        Comment

        • mkx
          Confirmed User
          • Nov 2003
          • 4001
          #3
          okay

            Comment

            • mkx
              Confirmed User
              • Nov 2003
              • 4001
              #4
              hmm i think he fell asleep

                Comment

                • hjnet
                  Confirmed User
                  • May 2002
                  • 3815
                  #5
                  Hmmm, I think you're expecting a bit too much from GFY

                    Comment

                    • 96ukssob
                      So Fucking Banananananas
                      • Mar 2003
                      • 12991
                      #6
                      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

                        Comment

                        • Jarmusch
                           
                          • May 2003
                          • 12479
                          #7
                          Why do you want to display the contents of sheet 2 column B on sheet 1 column B?

                            Comment

                            • mkx
                              Confirmed User
                              • Nov 2003
                              • 4001
                              #8
                              taking screenshot, brb

                                Comment

                                • mkx
                                  Confirmed User
                                  • Nov 2003
                                  • 4001
                                  #9


                                  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.

                                    Comment

                                    • mkx
                                      Confirmed User
                                      • Nov 2003
                                      • 4001
                                      #10
                                      bump for database being back up

                                        Comment

                                        • Brat
                                          Got MIDs?
                                          • Jan 2003
                                          • 1545
                                          #11
                                          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)

                                            Comment

                                            • mkx
                                              Confirmed User
                                              • Nov 2003
                                              • 4001
                                              #12
                                              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)

                                                Comment

                                                • mkx
                                                  Confirmed User
                                                  • Nov 2003
                                                  • 4001
                                                  #13
                                                  nevermind working, forgot the commas, thanx so much

                                                    Comment

                                                    • Iron Fist
                                                      Too lazy to set a custom title
                                                      • Dec 2006
                                                      • 23400
                                                      #14
                                                      Originally posted by mkx


                                                      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...
                                                      Last edited by Iron Fist; 01-21-2010, 10:23 PM.
                                                      i like waffles

                                                        Comment

                                                        Previous template Next
                                                        Working...