Gliffix101
Board Regular
- Joined
- Apr 1, 2014
- Messages
- 81
A A | B 3 | C M | D | E GENBPAPP |
A | 3 | S | GENBPAMIN | |
A | 1 | SE | SEBPA | |
B | 1 | M | GENLPA | |
B | 1 | A | GENLPA | |
A | 3 | S | CU | CUAMIN |
<tbody>
</tbody>
Hello,
I have the above table (which I hope the format sticks around) as a lookup. I have rows of data that contain values. am looking for a formula or vb logic that will look up the row data, compare to columns A, B, C, and D above, and return the value in E.
For example:
If
A1 = "B"
B1 = "1"
C1 = "M"
D1 = (Blank)
ThenSet E1 = "GENLPA"
This formula (if formula) would need to be able to be copied down the entire Column E. If vb, I need it to be able to loop until "LastRow".
LastRow defined as:
Code:
"LastRow = Range("A1").End(xlDown).Row"
NOTE: This is just a sample table, the actual lookup grid is 5 columns x 28 rows. Excel seems to cap IF statements at 7 arguments, so I couldn't get past the first 7 rows.
Thanks!