Is it possible to write a formula that #1 has to look in a column for a
specific word and then if it is there then #2 goes to a previous tab and
grabs the information that is the last thing typed in that column?

Hope this makes sense.

Many thanks