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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Re: Help needed w/VLOOKUP
Too unspecific info. Where are you wanting to run the look up formula?
Too unspecific info. Where are you wanting to run the look up formula?
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.
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
Similar threads
- Question
