Hi!
I have a table that has different voltages (24, 36, 48, and 80) on the rows and different charges (Charger 1, Charger 2 and charger 3) as columns. For every voltage, there are Three corresponding Amps depending on the charger. I want the user to type in 1) The voltage (either 24, 36, 48 or 80) and 2) The Amps it has (could be any number). Then I want Excel to look in the table and find the Amp that is most suitable, that is the Amp that corresponds to that voltage AND gives the Amp that is closest greater than the input Amp. So for example, if the user types in 24 Volt and 100 Amps (and in the table for 24 volts charger 100 gives 120 amps, charger 2 200 Amps and charger 3 80 Amps) It should say 120 Amps. I tried index match functions but I can't get it to work.. any ideas? I tried screenshotting the table but I don't understand how it works, tell me if I should clarify!
I have a table that has different voltages (24, 36, 48, and 80) on the rows and different charges (Charger 1, Charger 2 and charger 3) as columns. For every voltage, there are Three corresponding Amps depending on the charger. I want the user to type in 1) The voltage (either 24, 36, 48 or 80) and 2) The Amps it has (could be any number). Then I want Excel to look in the table and find the Amp that is most suitable, that is the Amp that corresponds to that voltage AND gives the Amp that is closest greater than the input Amp. So for example, if the user types in 24 Volt and 100 Amps (and in the table for 24 volts charger 100 gives 120 amps, charger 2 200 Amps and charger 3 80 Amps) It should say 120 Amps. I tried index match functions but I can't get it to work.. any ideas? I tried screenshotting the table but I don't understand how it works, tell me if I should clarify!
