Free. Exclusive. Just for you.
Four unique services that make learning easier, faster, and smarter - only on our website.

VLOOKUP formula in Excel to retrieve item amounts based on region and item name.

Excel spreadsheet showing a VLOOKUP formula in cell C2 to find the amount for "Oranges" in the "East" region, with a fallback to "West" if not found.

Excel spreadsheet showing a VLOOKUP formula in cell C2 to find the amount for "Oranges" in the "East" region, with a fallback to "West" if not found.

PNG 538×299 8.2 KB Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #1053548
Print Download

How to use

Click Print to open a print-ready version directly in your browser, or use Download to save the file to your device. The ⭐ Answer button generates an AI answer key instantly - useful for teachers who need a quick reference. Need a different version? Our AI Worksheet Generator lets you create a custom worksheet on any topic in seconds.

(view all vlookup across worksheet)

VLOOKUP from another sheet - Excel formula | Exceljet
VLOOKUP Multiple Sheets Names Using the INDIRECT Function –
How to Use VLOOKUP across worksheets in MS Excel 2007 « Microsoft ...
Have Vlookup Return Multiple Columns in Google Sheets
XLOOKUP across multiple Worksheets - Excel Formula
VLOOKUP from another sheet - Excel formula | Exceljet
Lookup Values Across Multiple Worksheets in Excel - Xelplus ...
VLOOKUP - Multiple Sheets at Once - Excel & Google Sheets ...
Excel VLOOKUP Multiple Sheets • My Online Training Hub
VLOOKUP from Multiple Worksheets (Tabs, Sheets) or Spreadsheets ...