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