Google Sheets

Owned by jimm1
Last updated: May 28, 2024
3 min read

Key Points


References

Reference_description_with_linked_URLs_______________________Notes______________________________________________________________















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

sample code block



Recommended Next Steps