In MS Excel a formula that looks for a value in left most column of a table and then returns a value in the same row for specific column:

A ) Horizontal Lookup

B ) Vertical Lookup ✅

C ) Average

D ) None of these