Vlookup & Hlookup

• Google Sheets and Excel as same way of functioning and same formula syntax for  Vlookup and Hlookup.
• Below are methods to perform Vlookup and Hlookup.

Sample Table:

• Below are the tables of Racers Participating in Race and Winning Position.
• Using this tables I will perfom Vlookup and Hlookup.

VLookup:

• Vlookup is nothiing but Vertically looking for data in a sheet using a reference.
• Syntax "=Vlookup(search_key, range, index, [is_sorted])".
• In Below, I have searched for Racer Jersey No, Racer Car Model from Racers table.

Hlookup:

• Hlookup is nothing but Horizontally Looking for data in a sheet using a reference.
• Syntax "=Hlookup(search_key, range, index, [is_sorted])".
• In Below, I have searched for Racer Name from Wining Table.