Hi there,
I'm trying to write a VLOOKUP formula but having a bit of trouble.
I'd like to perform a vlookup that only return to Today's date to a specific cell on that row or blank if FOUND. I am working with two sheets. Sheet 1 and sheet 2
This is what I currently have - =IFERROR(VLOOKUP(B3,sheet2!B:B,1,FALSE),TODAY())
1. This is working but the results appears where i put the Vlookup formula - I what the result in the H column
2. When found it is returning the value - I want it blank
3. The Date is returned as a number - I want it to be formatted as str(dd/mm/yyyy)
Thanks!
I'm trying to write a VLOOKUP formula but having a bit of trouble.
I'd like to perform a vlookup that only return to Today's date to a specific cell on that row or blank if FOUND. I am working with two sheets. Sheet 1 and sheet 2
This is what I currently have - =IFERROR(VLOOKUP(B3,sheet2!B:B,1,FALSE),TODAY())
1. This is working but the results appears where i put the Vlookup formula - I what the result in the H column
2. When found it is returning the value - I want it blank
3. The Date is returned as a number - I want it to be formatted as str(dd/mm/yyyy)
Thanks!