Hello,
I'm desperate, i have a lot of recors and can not do this by checking it one by one, because it's a montly assignment.
I have an excel Worbook which consists of 2 sheets. Each of them have columns from A to AQ and about 17000 rows. What do i need to do: If value of E2 in Sheet1 is Equal Value from E:E in Sheet2 than find the row in which they are equal in Sheet2 and copy from the exact row column F Sheet2 to F2 Sheet1 and from the exact row column G Sheet2 to Q2 in Sheet1.
VLOOKUP doesn't do the job, because it finds the Value that is equal, but can't copy info from exact column in which it maches.
Sorry for my english, i'm not an english speaker.
Thank you in advance,
kapas
I'm desperate, i have a lot of recors and can not do this by checking it one by one, because it's a montly assignment.
I have an excel Worbook which consists of 2 sheets. Each of them have columns from A to AQ and about 17000 rows. What do i need to do: If value of E2 in Sheet1 is Equal Value from E:E in Sheet2 than find the row in which they are equal in Sheet2 and copy from the exact row column F Sheet2 to F2 Sheet1 and from the exact row column G Sheet2 to Q2 in Sheet1.
VLOOKUP doesn't do the job, because it finds the Value that is equal, but can't copy info from exact column in which it maches.
Sorry for my english, i'm not an english speaker.
Thank you in advance,
kapas
