Hello expert,
I have a google sheet that I want to find and match data from importrange, if match add status.
Here's google sheet link for edit: https://docs.google.com/spreadsheets...kMA/edit#gid=0
SETUP
There are 3 tabs. MAIN tab I own and hope to combine all data here.
Complete and Pending tab are importrange controlled by someone else.
NEED
In A2 down, I want to fill with status label if C2 down is found and match in Complete or Pending tab. (eg. C2 job id is gggw, found in Pending tab, so A2 will fill "pending")
Thank you so much in advance!
Bookmarks