I have a problem where I'm currently using a VLOOKUP function on this sheet. LINK

What I wanted to happen is VLOOKUP would search on the List on G column and compare it to B column and if it matches. It will return a value y. The problem I encountered is it can't search from a list.

If anyone can help me. That would be great.

  • your sheet is private. share it or edit your question and add formula you are using
    – user0
    Feb 28, 2019 at 10:05

1 Answer 1


your VLOOKUP should look something like this:

=ARRAYFORMULA(IF(IFERROR(VLOOKUP(B2:B; List!G2:G; 1; 0); )<>""; "y"; ))

  • Thanks for this. I found a solution earlier while waiting. Feb 28, 2019 at 10:21

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.