Answer by
UmeshG (404)

For that you have to use formula 'VLOOKUP' which you can find in Excel file in formula the formula work like this VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)also you can use "HLOOKUP" and it work like this HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)