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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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