Vlookup with "IF" statements

scobad

Board Regular
Joined
Feb 7, 2005
Messages
164
Situation:
B9 can be one of four values
- License
- Test
- Driver
- Course

(I have this right now in a drop-down (List)

On the sheet accomp!F2:Q976 are a bunch of values that are tied to one of those four B9 values
Each type can have multiple rows or types (Example)
Type Item ID Descr Type
License/Cert 911PST 911 Pub Safe Telecommunicator
License/Cert ACLS Advanced Cardiac Life Support
License/Cert ACLS INS Adv Cardiac Life Support Instr
License/Cert ACLS PRO ACLS Provider
License/Cert AICP Amer Instit of Cert Planners


If the use Drops B9 to be "Driver" I would like it to return something from the accomp!F2:Q976 page and return Column 9
(which is the TYPE) and they would have a SELECTION box to choose one of the types based on the B9 value...

In summary -when a user selects a value in B9, they get a drop down of ONLY those types from the accomp page...

So lost now...
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,652
Messages
5,838,610
Members
430,557
Latest member
MK15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top