VLOOKUP | Searching in different ranges
Our mission is to get the price from these 2 tables using the VLOOKUP.
We add the second table beneath the first one using the array.
The price is the second column in the range.
Type 0 to exact match.
The search key is the value of cell B2.
Watch video VLOOKUP | Searching in different ranges online without registration, duration hours minute second in high quality. This video was added by user Google Workspace Tutorial 10 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 63 once and liked it 7 people.