VLOOKUP with another sheet with matching data


I am trying to do a VLOOKUP from another sheet based on a value in my current/new sheet. I want to MATCH the Task Name column first, THEN go to column 41(old sheet) and enter the date from that column onto my new sheet.

This is what I have, but I am a bit lost in the weeds. I could be very wrong about my code. Any help is appreciated!

=IF(VLOOKUP(([Task Name]8), {Old Range 1}, 1, [false])=[Task Name]8,"(VLOOKUP(ISDATE{Old Range 2},41,false))"," ")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!