Hello,
I'm having some issues around a simple vlookup using dates. I have include screenshots to assist.
My formula looks as follows and I am getting a "invalid data type" error.
=VLOOKUP([Batch Helper]1, {Site Disposition - database (MASTER) Range 2}, {Site Disposition - database MASTER Range 1}, false)
I am trying to do as follows:
For the Task Due column, do a vlookup table to another sheet that looks for the "Batch Helper" number as per below screenshot in the first column "Master Row" and returns the corresponding "A-Due" date in the "Task Due" column.
I cannot seem to resolve the invalid data type error. I have also shown the "task Due" and the "A-Due" are both DATE column types.
any assistance would be great. The "A-Due" date is also populated by another formula as shown in the screenshot. Im not sure if this is causing the issue also,