Vlookup funtion

V-lookup function can find the value in the other range.

1.       Name a rang, what rang you want to look up.

2.       Use v-look up function ,

3.result show up

         4.copy the function to other cells

5. firona is not in list, so can not lookup, you also can do ifError function, to show if it do not in the cell, what show up

5-1 copy  vlookup function to if error function, in the Value if error put  what you want to show up.

5-2 the result