Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Find values in a 2D table and return the first column value in the corresponding row Google Sheets

I am trying to return the values of column A when a value is found in the column B to C. Values in table BC is unique

A B C
cow 2 5
goat 6 7

If I enter 6 or 7 I like to get goat, if I enter 2 or 5 I like to get cow. So far vlookup, index plus match not working.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

You may try:

=iferror(+tocol(index(if(B:C=6,A:A,)),1),"--")

Change 6 within the formula to the cell hosting the value

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading