Register
Log In
Unanswered
Home
New Member
March 21, 2017
Offline
Hi,
I am trying to lookup values in 2 sheets. The one sheet is where i type in my self, and the other sheet is some data i download. All data from the sheet i type in, is in the one i download. But not all data that is in the one i download is in the one i type.
So what i want to do is to see if they match up (they should). So when it says 5 in my sheet, it should say -5 in the data sheet. This is basically what i want to check, because if it doesn't match up something has gone wrong somewhere, and i have to find out what.
BUT then if the data is in the downloaded one, but not in the typed one. then that is the true value so it should just say either 0 or (-) saying that it has been checked.
I hope this makes any sense?
See Answer
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Hi uhrskov,
Maybe this is a starter for you.
On the lookup tab I first check if the number in column A exists in the next sheet. If it does, then give the value with the Vlookup.
In column C the same for the second tab.
So you can see on one sheet which ones you have to check etc.
You can make the two sheets in table format, so it's easier to reference and you can do something with conditional formatting on the Lookup tab to make it more visible.
Answers Post
Most Users Ever Online: 57
Currently Online: Mark Lund, Max Neumann
22 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
