mrafiq44

New Member
Joined
Oct 14, 2015
Messages
28
I have data in 6 columns in one worksheet Name, Key, Status, Locations, Type, Datasource and then another worksheet with the same columns, but there are other columns in between. How can i run a vlookup to ensure data agrees in all columns? Can someone please help.
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Re: Help needed w/VLOOKUP

I just want to match the information in the two worksheets, preferably on the original worksheet.
 
Upvote 0
Re: Help needed w/VLOOKUP

Based on what value? The vlookup needs a value to search for.

If all of the rows are the same you might be better off just doing a cell reference on Sheet-2 back to the same cell on Sheet-1.

So on Sheet-1 in Cell A2, which would be the first "Name' value, just put in =Sheet-1!a2

This would populate the cells for what you need, no need for lookups.
 
Upvote 0

Forum statistics

Threads
1,216,750
Messages
6,132,505
Members
449,730
Latest member
SeanHT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top