I am trying to use the =IF(ISNA function with vlookup to put the COST from sheet two on to sheet one based on the MFg#. As you can see Sheet two does not contain Mfg# 33331. My function does return a 0, but the My question is why does it return a 0 for the rows below it when in fact those Mfg# are listed in Sheet 2?
Here is my function:=IF(ISNA(VLOOKUP(A2:A6,Sheet2!A1:B4,2,0)),"0",VLOOKUP(A2:A6,Sheet2!A1:B4,2,0))
I start this function on cell E2 then just copy the function down when I do you can see the result I get.
It should only return a 0 for item 33331 and not 4444 and 5555.
Sheet 1
A B C D E
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
A B
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
Here is my function:=IF(ISNA(VLOOKUP(A2:A6,Sheet2!A1:B4,2,0)),"0",VLOOKUP(A2:A6,Sheet2!A1:B4,2,0))
I start this function on cell E2 then just copy the function down when I do you can see the result I get.
It should only return a 0 for item 33331 and not 4444 and 5555.
Sheet 1
A B C D E
Mfg # | cost | markup | Final Price | Premier Price |
1111 | $4.70 | 3.75 | 4.88 | $4.70 |
2222 | $4.70 | 3.75 | 4.88 | $4.70 |
33331 | $4.40 | 3.75 | 4.55 | 0 0 |
4444 | $4.40 | 3.75 | 4.55 | 0 0 |
5555 | $10.00 | 3.75 | 10.38 | 0 0 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
A B
1111 | $4.70 |
2222 | $4.70 |
4444 | $4.40 |
5555 | $10.00 |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>