Could you kindly tell me if there is a function that can help me with this situation?

I am working with two sheets on drive and I would like to know if there is a possibility to make some sort of confirmation if the information from another sheet is on the other sheet o not and, if we can show it where this cell is. With the link bellow, I think it will be easier to understand.


I made some comments trying to explain it a bit better.

I already thank you for everything and wish you all a happy new year.

  • Welcome to Web Applications Stack Exchange. The sample spreadsheet gives "Options to download print and copy have been disabled on this file" which makes it hard to develop a solution. Please modify the sharing settings so that the spreadsheet can be edited or at least copied. Also show the desired result for the first three companies. Jan 6 at 8:53
  • Hello, thank you for your help, I have allowed anyone with the link to edit the sheet. docs.google.com/spreadsheets/d/… Jan 6 at 11:39

1 Answer 1


Use this to fill the state into every company row:

=arrayformula( if( len(C4:C); A2; iferror(1/0) ) )

...and this to look up those states per company:

=arrayformula( iferror( vlookup(A2:A; { 'COMPANY STATE'!C4:D; 'COMPANY STATE'!G4:H }; 2; false) ) )

See your sample spreadsheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.