making a Y/N column based on text

[Jaimee001]

Good afternoon!!!

I have a report where I need to add a Y/N based on the name of the account.

tab1:Col a acct no, Col b name of account Col C Y/N

tab2:Col a-name of account

I've tried to do a vlookup formula, a match formula and an index formula and I can't get any to work.

Here is where my test file is:

[pre]http://speedy.sh/6fmTN/example-for-vlookup-based-on-text.xlsx[/pre]


Thanks in advance!

 

[SirJB7]

Hi, Jaimee001!


VLOOKUP & INDEX functions retrieve the value of a cell contents, MATCH function retrieves a number indicating position of a value within a range.

For getting a Y/N value, you should use VLOOKUP or INDEX in an IF formula to set the desired output.

With the first, try this:

=SI(ESERROR(BUSCARV(B2;'Look up'!A:A;1;FALSO));"N";"Y") -----> in english: =IF(ISERROR(VLOOKUP(B2,'Look up'!A:A,1,FALSE)),"N","Y")


Regards!

 

[Jaimee001]

SIRJB7 Thank you so much!!!!! I had such a hard time making the formula work, so I walked away, went grocery shopping, came back looked at it again and it worked!!!


Thank you again!!!

 

[SirJB7]

Hi, Jaimee001!

Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!

PS: The grocer man also helped you with Excel? Wow... it's highly recommendable that shop!