Nesting VLOOKUP functions Is it possible to nest VLOOKUP functions, using an IF/

Question

Nesting VLOOKUP functions

Is it possible to nest VLOOKUP functions, using an IF/OR IF  scenario in EXCEL 2013? For instance, I track an inventory in a workbook with three tabs; Unassigned, Assigned, and Deactivated. To generate my monthly activity reporting (without having to manually enter data into another spreadsheet), I would need to pull information from all three tabs, based on the activity date, serial number and status of the item, looking at each of the three tabs. Just not sure that this can be done....

Thanks !!

Explanation / Answer

Hi..

Yes, it can be done.

Use IFERROR functionality like this.

=IFERROR(VLOOKUP Formula from One Tab, IFERROR(VLOOKUP Formula from second Tab,VLOOKUP Formula from Third Tab));

Like this you may add any number of Tabs...

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.