Vlookup to return today's data if not found and blank if found

[Benny1145]

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!

 

[etaf]

try
=IF(ISERROR(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

can you put the formula into column H - not sure i follow exactly

When found it is returning the value - I want it blank

change formula to
=IF(ISERROR(VLOOKUP(B3,Sheet2!B:B,1,FALSE)),TODAY(),"")

3. The Date is returned as a number - I want it to be formatted as str(dd/mm/yyyy)

just format the column as a Date DD/MM/YYYY

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)