Hi!
I am relatively OK with the basic IF and VLOOKUP statements but anything that requires calculation from multiple cells that gets me a little bit lost.
I will try to explain exactly what I am trying to do, hopefully it makes sense.
I want cells D through H to populate from the information I enter into cells A through C.
IF A2 = "W" and B2 = "I" and C2 = "H", then look in other sheet for header "W/I/H"
Other sheet has several tables - each of which are three columns giving all possible values to "H", "A" and "D"
The table with header "W/I/H" contains all possible values of "H", "A" and "D" if all three "W/I/H" cells are met
If the table with header "W/I/H" only contains one possibility of "H" = 13 and "A" = 12 and "D" = 12, then populate cells D2 to F2 with the values of the one possibility
If more than one possibility exists, populate cells D2 to F2 with a drop-down selection from another sheet but display the words "Multiple Results" in the cell
In cell G2, add the three values from D2 to F2 together out of a total of 45 and provide a percentage.
Repeat for all tables depending on what is in cells A, B and C in each row.
Please see here for examples of results received as I can't figure out how to format a table in this forum
https://www.mrexcel.com/forum/excel-...ple-cells.html
P.S. I don't have to have tables, any suggestions on how best to store the data are welcome.
Bookmarks