Answer:
This seems to be related to MS Excel, here we will discuss the related formula:
<u>=IF(VLOOKUP("Adam Moriarty",$B$3:$C$5,2)>23,"Yes","No")</u>
the name can also be written in adjacent to J2 cell i.e. I2 and its reference to be used in vlookup primary key as follows:
<u>=IF(VLOOKUP(I2,$B$3:$C$5,2)>23,"Yes","No")</u>
Explanation:
We have used simple IF function combined with VLOOKUP function to reference this formula to the table of names and ages of the members (here the table is $B$3:$C$5 and ages are mentioned in 2nd column of the table)
please find attached screenshot for clarification
