Hello to all,
As I have read around, Vlookup only show first or last results depending if FALSE or TRUE variable is used in the formula.
Here the issue I'm trying to solve.
In column A & B I have data. A shows employee number, B a working date.
I want screen A:B (using a function?) and return the values in the table on the right.
If employee number and a date is found in the list (A:B) it returns TRUE, otherwise FALSE.
I was thinking VLookup could do that.
Any help is much appreciated!
Thanks
Claude
As I have read around, Vlookup only show first or last results depending if FALSE or TRUE variable is used in the formula.
Here the issue I'm trying to solve.
In column A & B I have data. A shows employee number, B a working date.
I want screen A:B (using a function?) and return the values in the table on the right.
If employee number and a date is found in the list (A:B) it returns TRUE, otherwise FALSE.
I was thinking VLookup could do that.
Any help is much appreciated!
Thanks
Claude