Auto fill cell value if adjacent cell matches cell in another sheet.
I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on my main RFI Log.
my main log: 1st column is RFI #, and 2nd column is internal tracking number
from issue tracking log:
The second line from my issue tracking log has 372, which matches 372 on my main log. Can I somehow insert a function that will auto populate the blank cell with the RFI # 2878? I would like function to work for the entire column of blank cells, not just for 372 specifically.
Help Article Resources
Check out the Formula Handbook template!