Use VLOOKUP In the Formula Bar type VLOOKUP. Applying the Formula of If Statement ISNA and Vlookup Just put the name of the fruit in cell E2 and cell C11 will give you the result you are looking for. VBA Lookup - Unable to get the Vlookup property of the WorkSheet function class.
For more information about field codes see the See Also section.
It also has a drop down box that will let you select from a list. VLOOKUP Formula VLOOKUP lookup_value table_array col_index_num range_lookup To translate this to simple English the formula is saying Look for this piece of information in the following area and give me some corresponding data from another column. In VLOOKUP col_index_no is a static value which is the reason VLOOKUP doesnt work like a dynamic function. Heres how the formula for this type of search should look like.