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
    Commented Feb 18, 2020 at 15:17
  • Glad it worked for you. Please remember that you can also upvote the answer. Commented 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
    Commented Feb 21, 2020 at 23:19
  • "....I haven't reached a high enough level" Yes you have. Have a look at your privileges scale Commented 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
    Commented Feb 22, 2020 at 0:52

Your Answer

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

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