Forum Discussion
IF TEXT FUNCTION
Hi,
I would like F14 to State 'Yes' if either cells D14 or E14 contain 'TRUE'
D14 and E14 are both results from the following formula;
=IFNA(B14<>"","No")
=IFNA(C14<>"","No")
Which in turn following from cells B14 AND C14 which contain;
=VLOOKUP("*"&A14&"*",Home,1,FALSE)
=VLOOKUP("*"&A14&"*",Away,1,FALSE)
I'm trying to find a way for Excel to do an approximate vlookup for a name from a set of data and then if it is present in one of two table arrays when it states 'Yes'. So far I've had to go across multiple cells to get to this stage.
Picture attached should help;
Kind regards,
Marc
Hi Marc,
If you need only Yes or No in result that could be like
=IF(IFNA(VLOOKUP("*"&A14&"*",Home,1,FALSE),"No")="No","No","Yes")
Hi Marc,
If you need only Yes or No in result that could be like
=IF(IFNA(VLOOKUP("*"&A14&"*",Home,1,FALSE),"No")="No","No","Yes")Thank you - It worked perfectly.
Is there a way for the formula to check two different table arrays in the same formula?
Marc, you may try
=IF(IFERROR(VLOOKUP("*"&A14&"*",Home,1,FALSE),IFNA(VLOOKUP("*"&A14&"*",Away,1,FALSE),"No"))="No","No","Yes")
