IF 3 variables then return a specific #

**rkerns1** · 04-01-2009, 03:30 PM

I've attached the example spreadsheet.
I have 3 columns with multiple variable rows.
The 4th column is the specific result for those 3 variables.
I need a formula/s that will give me the correct 4th column # based on the previous 3 columns what would be input using dropdown lists I believe.

So for instance the final end result would be an HTML web page with 3 drop down boxes representing the first 3 columns and then based on what is selected in those 3 dropdowns the correct 4th column # would be shown.

Any help would be greatly appreciated by this great community.

**rkerns1** · 04-01-2009, 04:36 PM

Please someone help me out.
I'm in an urgent need.

**JBeaucaire** · 04-01-2009, 05:24 PM

Give this a look. My favorite trick for multi-cell matching is to automatically create a unique key for each row from the 3 variables. Makes things easy in a lookup.

**rkerns1** · 04-01-2009, 05:39 PM

You're the man, thank you so much.
That does work perfectly in Excel.

Any insight on how to make that into a webpage that will work also with just the 3 drop down boxes and the resulting $ amount?

**JBeaucaire** · 04-01-2009, 05:53 PM

Set the workbook up on Googlesheets, then you don't have to do anything differently.

**rkerns1** · 04-01-2009, 06:02 PM

Good thought but eventually this Excel doc/data/formulas will be the background for an actual web page where customers will be able to input their variables in the dropdowns and be given their $ amount.

So I'm hoping there is a quick easy way to go about that.