Hi,
Trying to create a formula to create a New table from an Existing table.
It'll have (3) lookup values. You'll need to enter the values in the (lookup values) area.
Load Capacity (Enter one: 500#, 1000#, 2000# or 4000#)
Emission Type (Enter one: Gas, Diesel or Electric)
Horse Power (Enter one: 150, 200 or 250 or 300)
After entering all (3) lookup values, it would check the Existing table for all matching values and display the matching values insides the New table.
I've searched and found I can do this but with only (1) lookup value.
I've attached an excel file showing the (1) lookup value that works for Load Capacity.
Can someone help me out? Is there an easier way, using formulas?
Bookmarks