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

give me a sec

http://www.thirteen.org/edonline/les...s/hawkings.gif

okay :):)

hmm i think he fell asleep :(

Hmmm, I think you're expecting a bit too much from GFY :)

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

Why do you want to display the contents of sheet 2 column B on sheet 1 column B?

taking screenshot, brb

http://img340.imageshack.us/img340/3507/excelu.jpg

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.

bump for database being back up :)

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)

yes thats exactly what i want to do. tried it but doesn't seem to work, returns N/A.

nevermind working, forgot the commas, thanx so much

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...