Hello,
I need help with vlookup please, can't seem to get it working. Probably i am missing something here.
I'm trying to extract info from column A in to column F by comparing 'B' and 'E'.
Formula used in column F: =VLOOKUP(E66,A:B,1,FALSE)
[TABLE="width: 621"]
<tbody>[TR]
[TD]FN1[/TD]
[TD]FN2[/TD]
[TD][/TD]
[TD][/TD]
[TD]FN3[/TD]
[TD]FN1[/TD]
[/TR]
[TR]
[TD]DES00007[/TD]
[TD]CZC20601SX[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2510LJW[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00132[/TD]
[TD]CZC2510LH2[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2510LK9[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00274[/TD]
[TD]CZC20601T9[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L00[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00293[/TD]
[TD]CZC2510LJK[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L1J[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00298[/TD]
[TD]CZC20601VN[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L0V[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00311[/TD]
[TD]CZC20601T1[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L1C[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00325[/TD]
[TD]CZC20601S6[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601S0[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00409[/TD]
[TD]CZC20601RP[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2097DYK[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00415[/TD]
[TD]CZC2097DYD[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601TY[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00431[/TD]
[TD]CZC2510LHS[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2184K06[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00442[/TD]
[TD]CZC2184JZ4[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601RW[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00452[/TD]
[TD]CZC2097DXS[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601RM[/TD]
[TD]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
Your help is much appreciated, thank you.
I need help with vlookup please, can't seem to get it working. Probably i am missing something here.
I'm trying to extract info from column A in to column F by comparing 'B' and 'E'.
Formula used in column F: =VLOOKUP(E66,A:B,1,FALSE)
[TABLE="width: 621"]
<tbody>[TR]
[TD]FN1[/TD]
[TD]FN2[/TD]
[TD][/TD]
[TD][/TD]
[TD]FN3[/TD]
[TD]FN1[/TD]
[/TR]
[TR]
[TD]DES00007[/TD]
[TD]CZC20601SX[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2510LJW[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00132[/TD]
[TD]CZC2510LH2[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2510LK9[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00274[/TD]
[TD]CZC20601T9[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L00[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00293[/TD]
[TD]CZC2510LJK[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L1J[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00298[/TD]
[TD]CZC20601VN[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L0V[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00311[/TD]
[TD]CZC20601T1[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC4122L1C[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00325[/TD]
[TD]CZC20601S6[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601S0[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00409[/TD]
[TD]CZC20601RP[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2097DYK[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00415[/TD]
[TD]CZC2097DYD[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601TY[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00431[/TD]
[TD]CZC2510LHS[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC2184K06[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00442[/TD]
[TD]CZC2184JZ4[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601RW[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]DES00452[/TD]
[TD]CZC2097DXS[/TD]
[TD][/TD]
[TD][/TD]
[TD]CZC20601RM[/TD]
[TD]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
Your help is much appreciated, thank you.