Finding date in other sheet and adding into current sheet

Hi Guys

I have a sheet with columns of information. One column has a "container number" which looks something like this "TCNU6307839"

A few rows down i need to enter a date for this "container number". This date is entered in another sheet with the same container number in a row. Now I'm manually copying the container number, opening the other sheet, searching for a match, then tab'ing across to the date and copying it and pasting it back in the original sheet.

I'm wondering if there is a formula that will allow me to search the second sheet, match the container number in one column and pull the date a few cells further down the row and enter it into my current sheet?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!