# How to Use VLOOKUP in Google Sheets

Viewport: 1920x951 @0.75x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Use VLOOKUP in Google Sheets
   - body: This guide provides a detailed walkthrough on how to use the VLOOKUP function in Google Sheets. Follow these steps to seamlessly retrieve data from a table or range.
   - voiceover: This guide will walk you through the steps needed to effectively use the VLOOKUP function in Google Sheets. This powerful function allows you to look up data from one table and use it to populate fields in another, saving you time and reducing the risk of errors.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg95b8000k0cl28yhm4eys.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Click into the cell where you want the result of the VLOOKUP function to appear.
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (1170.634837196783, 459.3337951746095), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (1170.634837196783, 459.3337951746095), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click into the cell where you want the result of the VLOOKUP function to appear.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg99g5000m0cl2cwi3buz1.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg1lbm0000033phh4vcrf7.png
2. step_02 [image] - Click on the input bar to write the formula
   - source type: IMAGE
   - description: Click into the cell
   - target: (323.00250576011746, 116.33373894251058), rect: top=115.66667175292969 left=142.1666717529297 width=2417.83349609375 height=26
   - hotspots: 1
     - hotspot_01 (323.00250576011746, 116.33373894251058), rect: top=115.66667175292969 left=142.1666717529297 width=2417.83349609375 height=26
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click on the input bar to write the formula. Type =VLOOKUP(search_key, range, index, [is_sorted]) where search_key is the value to search for, range is the table to search within, index is the column number in the range from which to retrieve the value, and is_sorted is TRUE or FALSE depending on whether the range is sorted.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg99gq000n0cl2gudnf3wf.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg1nrt0001033pg2vjxeba.png
3. step_03 [video] - Click here
   - source type: VIDEO
   - target: (1101, 478), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (1101, 478), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - clip: start=20.7 end=73.095 duration=52.394999999999996
   - video: url=https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg1gnf006t0clb9lqmebvs.webm speed=2.5 muted=true
   - voiceover: The formula is search-key, range, index, and optional input if it is sorted. Select the cells according to your preference.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg849k006w0clb11yl0w5p.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg1gnf006t0clb9lqmebvs.webm
4. step_04 [image] - The LookUp result is in the cell.
   - source type: IMAGE
   - description: Click the Function drop-down
   - target: (1144.3625775397925, 473.18187543236417), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (1144.3625775397925, 473.18187543236417), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Press Enter, and the VLOOKUP result will appear in the selected cell.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg99hb000o0cl20q4vbphp.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg34f30003033p5jrkfwac.png
6. [Outro] Next Steps
   - body: You've successfully used the VLOOKUP function! For further assistance on advanced functions or troubleshooting, refer to advanced tutorials or Google Sheets support documentation.
   - voiceover: You can now use this method to perform VLOOKUP in different cells and sheets within your Google Sheets document. Experiment with different ranges and conditions to become more proficient with this function.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hg1gma006nlb0c2isoznuo/cm6hg97jd000l0cl22ryy5ha2.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6hg1gma006nlb0c2isoznuo/tour