Forum Discussion
3 CELLS LOOKUP AND DISPLAY DATA
Looking for some help, I have basic formula experience with excel. I have a this "table" (I'm sure my terminology is incorrect) that is my "reference" if three separate cells on a separate sheet match any of the three rows in the table then it would display the fourth row of the table in a separate cell next to the three cells where the data is entered? This would all be on a separate page. The "choices" would be for the three cells would be a drop down menu with the selection with the corresponding rows from the "table" and the fourth cell would obviously the display. Any help would be greatly appreciated!
Table
| S1 | E0 | A0 | Negligible |
| S1 | E1 | A1 | Negligible |
| S1 | E1 | A2 | Low |
| S1 | E1 | A3 | Low |
| S2 | E0 | A0 | Low |
| S3 | E0 | A0 | Low |
| S2 | E1 | A0 | Med |
| S2 | E2 | A1 | Med |
| S2 | E2 | A2 | High |
| S2 | E2 | A3 | High |
| S3 | E1 | A0 | High |
| S3 | E2 | A1 | High |
| S3 | E2 | A2 | High |
| S3 | E3 | A3 | Very High |
If you'll insert values always in S E A order, check the attachment for details.
If you'll insert S E A values in any order, that needs more work to adjust it.
Awesome, Thank You!!
