Nested formula required for two cell inputs and a single cell output

Hi!

Looking for some help with a nested formula (or an alternative method to achieve the same task) for following:

I have two blank cells - C12 and C13. Depending on the inputs of these cells, I require a set output in cell C15.

Result required in C15 to be determined from inputs as below:

C12 In_______C13 In______C15 Out
___1____________2________Kentec XT
___1____________4___Kentec XT+ 1 Area 4 Zone
___1____________6___Kentec XT+ 1 Area 8 Zone
___2____________2___Kentec XT+ 2 Area 2 Zone
___2____________4___Kentec XT+ 2 Area 4 Zone
___2____________6___Kentec XT+ 2 Area 8 Zone
___3____________2___Kentec XT+ 3 Area 2 Zone
___3____________4___Kentec XT+ 3 Area 4 Zone
___3____________6___Kentec XT+ 3 Area 8 Zone
___4____________2___Kentec XT+ 4 Area 2 Zone
___4____________4___Kentec XT+ 4 Area 4 Zone
___4____________6___Kentec XT+ 4 Area 8 Zone

Where the conditions above are not met (FALSE), C15 should report "Please enter correct information above".

Have tried nesting IF AND formula but a little beyond my level of EXCEL!!

Any help would be hugely appreciated.

See my attached sheet and see it as an example of a solution you can use. Note, the formula used is an array formula that needs to be applied with Ctrl + Shift + Enter, instead of just Enter.

=IFERROR(INDEX($J$1:$J$12,MATCH(1,($H$1:$H$12=$C$12)*($I$1:$I$12=$C$13),0)),"Please enter correct information above.")

- Moo

This seems to work. Added some datavalidation but it handles error fine without it.

Formula:

Please Login or Register  to view this content.

titch2k6,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thanks for the rep. Sorry I didn't get back sooner, was afk most of the day.

- Moo