LinkBack URL
About LinkBacks
Hi all,
Attached is an excel file which has an example of matching certain cells and then returning a date at a certain column.
Please try and help.
Regards
Jake
Hi all,
Attached is an excel file which has an example of matching certain cells and then returning a date at a certain column.
Please try and help.
Regards
Jake
something like this...
=VLOOKUP("*"&B7&"*",B3:C3,2,FALSE)
then issue iferror
finish formula
=iferror(VLOOKUP("*"&B7&"*",B3:C3,2,FALSE),"display this if not found")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi Vlady,
The formula does not give the date but rather gives a value in the column d7.
What am i doing wrong?
Jake
did you format the cell as date??
you'll receive 41095 ---date: 7/5/212
Re: Matching case with a date
Hi
Had forgotten that.
Now it works
Thanks alot
Jake
welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks