Key Points

References

Key Concepts

Google Sheets Lookups

examples of using a vertical lookup and a horizontal lookup where the lookup value is in a different sheet than cell where the lookup value will be used in google sheets

examples of both a vertical lookup (VLOOKUP) and a horizontal lookup (HLOOKUP) in Google Sheets, with the lookup value being in a different sheet than the cell where the lookup value will be used.

Example 1: Vertical Lookup (VLOOKUP)

Sheets and Data

• Sheet1 (where we perform the lookup)

  • Cell A1: Lookup value (e.g., "Product A")
  • Cell B1: =VLOOKUP(A1, Sheet2!A, 2, FALSE)
    
    

• Sheet2 (where the data is stored)

  • Column A: Product Names
  • Column B: Prices

Steps

1. In Sheet2, list your products in Column A and their corresponding prices in Column B:

   mathematica

   A B 1 Product Name Price 2 Product A $10 3 Product B $20 4 Product C $30

   A B
   1 Product Name Price
   2 Product A $10
   3 Product B $20
   4 Product C $30

   

2. In Sheet1, enter the product name you want to look up in Cell A1 (e.g., "Product A").

3. In Cell B1 of Sheet1, use the VLOOKUP formula:

   plaintext

   =VLOOKUP(A1, Sheet2!A:B, 2, FALSE)

   This formula looks for the value in Cell A1 ("Product A") in the first column of the range Sheet2!A:B, and returns the value from the second column of the range (the price).

Example 2: Horizontal Lookup (HLOOKUP)

Sheets and Data

• Sheet1 (where we perform the lookup)

  • Cell A1: Lookup value (e.g., "Product A")
  • Cell B1: =HLOOKUP(A1, Sheet2!A1, 2, FALSE)

• Sheet2 (where the data is stored)

  • Row 1: Product Names
  • Row 2: Prices

Steps

1. In Sheet2, list your products in Row 1 and their corresponding prices in Row 2:

   mathematica

   A B C 1 Product A Product B Product C 2 $10 $20 $30

   

2. In Sheet1, enter the product name you want to look up in Cell A1 (e.g., "Product A").

3. In Cell B1 of Sheet1, use the HLOOKUP formula:

   plaintext

   =HLOOKUP(A1, Sheet2!A1:C2, 2, FALSE)

   This formula looks for the value in Cell A1 ("Product A") in the first row of the range Sheet2!A1:C2, and returns the value from the second row of the range (the price).

Summary

• VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from another column.
• HLOOKUP: Searches for a value in the first row of a range and returns a value in the same column from another row.

These examples should help you understand how to use VLOOKUP and HLOOKUP across different sheets in Google Sheets.

Potential Value Opportunities

Potential Challenges

Candidate Solutions

Step-by-step guide for Example

sample code block

Recommended Next Steps

Related articles