Hi,
I am trying to concatenate vlookup formula in one cell from two different table.
I am apply the following formula in formula required sheet but formula return NA.
B9=VLOOKUP(B$2,DATA!$G$4:$K$15,MATCH($A3,DATA!$H$2:$K$2,0)+1,FALSE)&VLOOKUP(B$2,DATA!$A$4:$E$15,MATCH($A3,DATA!$B$2:$E$2,0)+1,FALSE)
How to resolve the error. Please help me.
DATA SHEET:
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>FORMULA REQ SHEET:
RANGE A2:V6
<colgroup><col><col span="21"></colgroup><tbody>
</tbody>
I am trying to concatenate vlookup formula in one cell from two different table.
I am apply the following formula in formula required sheet but formula return NA.
B9=VLOOKUP(B$2,DATA!$G$4:$K$15,MATCH($A3,DATA!$H$2:$K$2,0)+1,FALSE)&VLOOKUP(B$2,DATA!$A$4:$E$15,MATCH($A3,DATA!$B$2:$E$2,0)+1,FALSE)
How to resolve the error. Please help me.
DATA SHEET:
TABLE 1 | A2:E15 | TABLE 2 | G2:K15 | |||||||
FRUIT | BLUEBERRY | BLACKCURRANT | BLACKBERRY | BILBERRY | FRUIT | BLUEBERRY | BLACKCURRANT | BLACKBERRY | BILBERRY | |
ORDER | Q1 | Q2 | Q3 | Q4 | ORDER | Q1 | Q2 | Q3 | Q4 | |
3969 | OK | OK | OK | OK | 4041 | QA | OK | QA | OK | |
4022 | OK | OK | OK | OK | 4019 | OK | OK | OK | OK | |
3987 | OK | OK | OK | OK | 4061 | OK | OK | OK | OK | |
3944 | OK | OK | OK | OK | 4079 | 0 | 0 | 0 | 0 | |
3994 | OK | OK | OK | OK | 4062 | OK | OK | OK | OK | |
3996 | OK | OK | OK | OK | 4068 | 0 | 0 | 0 | 0 | |
3995 | OK | OK | OK | OK | 4069 | 0 | 0 | 0 | 0 | |
4017 | OK | OK | OK | OK | 4080 | 0 | 0 | 0 | 0 | |
4067 | OK | OK | OK | OK | 4058 | 0 | 0 | 0 | 0 | |
4040 | QA | OK | OK | OK | 4000 | OK | OK | OK | OK | |
4065 | OK | OK | OK | OK | ||||||
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
RANGE A2:V6
FRUIT | 4041 | 4019 | 4061 | 4079 | 4062 | 4068 | 4069 | 4080 | 4058 | 4000 | 3969 | 4022 | 3987 | 3944 | 3994 | 3996 | 3995 | 4017 | 4067 | 4040 | 4065 |
BLUEBERRY | QA | OK | OK | 0 | OK | 0 | 0 | 0 | 0 | OK | OK | OK | OK | OK | OK | OK | OK | OK | QA | OK | |
BLACKCURRANT | OK | OK | OK | 0 | OK | 0 | 0 | 0 | 0 | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK |
BLACKBERRY | QA | OK | OK | 0 | OK | 0 | 0 | 0 | 0 | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK |
BILBERRY | OK | OK | OK | 0 | OK | 0 | 0 | 0 | 0 | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK |
<colgroup><col><col span="21"></colgroup><tbody>
</tbody>