Select the best answer
Views
Scenario Manager
Solver
Bookmarks
Concatenate
Consolidate
Containing
Filtering
Vector Lookup, V Lookup and W Lookup
Vector Lookup, H Lookup and Horizontal Lookup
Vector Lookup, H Lookup and V Lookup
HectorLookup, VLookup and Vector Lookup
=LOOKUP(B13,D3:D11,E3:E11)
=VLOOKUP(B13,D3:D11,E11)
=VECTORLOOKUP(B13,D3:D11,E11)
=VHLOOKUP(B13,D3:D11,E11)
Data Table
Scenario Manager
Goal Seek
Pivot Tables
Array for Data Table
Pivot Table
Vector Lookup
Data Validation
Ctrl H
Ctrl K
Alt H
Alt K
True
False
Icon Range Manager
Icon Range Name
Icon Name Designer
Icon Name Manager
False
True