1

This is my test sheet: https://docs.google.com/spreadsheets/d/11oiKLq6EWk9grdrtIKHT0NQ4naTX_tSPl7o8zAQP3Tc/edit?usp=sharing

My core information is in the sheet labeled "Information." In the sheet labeled "Query" I would like to have a formula look at the value in Query!A1 and compare it to Information!A1:A25.

Since Query!A1 matches Information!A2, then Query!B1 and Query!C1 should contain the corresponding information from Information!B2 and Information!C2.

1

1 Answer 1

1

The formula you need uses the VLOOKUP function:

=IFERROR(ArrayFormula(VLOOKUP(A1:A,Information!A1:C,{2,3},0)),)

Functions used:

Please check the answer in your sheet

5
  • Works exactly like I wanted! Thanks!!!
    – CJarbez
    Feb 18, 2020 at 15:17
  • Glad it worked for you. Please remember that you can also upvote the answer. Feb 20, 2020 at 19:02
  • I did up vote the answer, but I haven't reached a high enough level for it to count yet.
    – CJarbez
    Feb 21, 2020 at 23:19
  • "....I haven't reached a high enough level" Yes you have. Have a look at your privileges scale Feb 22, 2020 at 0:28
  • I tried it earlier and it didn't work. I just tried again and it worked. Oh well! It's there now!
    – CJarbez
    Feb 22, 2020 at 0:52

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.