1

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 at 10:05
0

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. – Jerome Agunod Feb 28 at 10:21

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.