CAPTURE VALUES FROM ONE SHEET AND POPULATE ON ANOTHER BASED ON A KEYWORD
Hi, I am trying to capture equipment number, year, make and model from my main sheet based on the status "available for transfer" and bring those values over to my calculation sheet to display on my dashboard. Below is what the main sheet looks like that I want to pull those values over to my other sheet based on the status "available for transfer"
Help Article Resources
Check out the Formula Handbook template!