Excel 2007, Windows XP...
I need a formula in cell Q7 that will return the value in the table, A2:K19, that match the intersection of the values in M7 and N7. Ex: M7=1211502, N7= K06 - MES_TargetRate, I need to return 46. I have a vLookup in column P but I do not want to change the row # every time the column N changes.
Thanks
I need a formula in cell Q7 that will return the value in the table, A2:K19, that match the intersection of the values in M7 and N7. Ex: M7=1211502, N7= K06 - MES_TargetRate, I need to return 46. I have a vLookup in column P but I do not want to change the row # every time the column N changes.
Thanks
Excel Workbook | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | F | G | H | I | J | K | L | M | N | O | P | Q | |||
2 | Code1 | K01 - MES_TargetRate | K02 - MES_TargetRate | K03 - MES_TargetRate | K04 - MES_TargetRate | K05 - MES_TargetRate | K06 - MES_TargetRate | * | * | * | * | * | * | ||
3 | 1033701 | * | 32 | 18 | * | * | * | * | product_code | characteristic_name | characteristic_value | RFS | * | ||
4 | 1104501 | 35 | 35 | 35 | 25 | * | * | * | 1062700 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 49 | #N/A | * | ||
5 | 1168700 | * | * | 18 | * | * | * | * | 1211500 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 30 | #N/A | * | ||
6 | 1168701 | * | * | 18 | * | * | * | * | 1211501 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 45 | #N/A | * | ||
7 | 1168901 | * | * | 20 | * | * | * | * | 1211502 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 46 | * * * 46 | * | ||
8 | 1169001 | * | * | 16 | * | * | * | * | 1211600 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 40 | #N/A | * | ||
9 | 1169101 | * | * | 20 | * | * | * | * | 1211601 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 40 | #N/A | * | ||
10 | 1169201 | * | * | 21 | * | * | * | * | 1211602 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 42 | * * * 42 | * | ||
11 | 1211000 | * | 34 | 18 | * | * | * | * | 1211700 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 46 | #N/A | * | ||
12 | 1211001 | * | 34 | 18 | * | * | * | * | 1211800 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 40 | #N/A | * | ||
13 | 1211101 | * | * | 26 | 38 | * | * | * | 1211801 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 40 | #N/A | * | ||
14 | 1211200 | * | * | * | * | 25 | * | * | 1211802 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 40 | * * * 40 | * | ||
15 | 1211201 | * | * | * | * | 25 | * | * | 1602800 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 38 | #N/A | * | ||
16 | 1211300 | * | 34 | 18 | * | * | * | * | 1602810 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 38 | #N/A | * | ||
17 | 1211400 | * | * | 26 | 30 | * | * | * | 1602900 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 26 | #N/A | * | ||
18 | 1211502 | * | * | 32 | 29 | 49 | 46 | * | 1603600 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 40 | #N/A | * | ||
19 | 1211602 | * | * | 32 | * | 49 | 42 | * | 1603601 | K06 - MES_TargetRate | * * * * * * * * * * * * * * * * * 45 | * * * 42 | 45 | ||
Sheet1 |