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?
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.
