Google sheets expert
Budget: $20 – $30 NZD
I have a few google sheets with a lot of names, phone numbers, and statuses see file 1 attached.
Then another sheet with names and numbers like file 2 attached,
I need a formula that will write the status in sheet 2 of each name in sheet 2 by checking the phone number to what status this number has in sheets 1
Then another sheet with names and numbers like file 2 attached,
I need a formula that will write the status in sheet 2 of each name in sheet 2 by checking the phone number to what status this number has in sheets 1