Help with VLOOKUP

[sunvad]

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)

FN1	FN2			FN3	FN1
DES00007	CZC20601SX			CZC2510LJW	#N/A
DES00132	CZC2510LH2			CZC2510LK9	#N/A
DES00274	CZC20601T9			CZC4122L00	#N/A
DES00293	CZC2510LJK			CZC4122L1J	#N/A
DES00298	CZC20601VN			CZC4122L0V	#N/A
DES00311	CZC20601T1			CZC4122L1C	#N/A
DES00325	CZC20601S6			CZC20601S0	#N/A
DES00409	CZC20601RP			CZC2097DYK	#N/A
DES00415	CZC2097DYD			CZC20601TY	#N/A
DES00431	CZC2510LHS			CZC2184K06	#N/A
DES00442	CZC2184JZ4			CZC20601RW	#N/A
DES00452	CZC2097DXS			CZC20601RM	#N/A

<tbody>
</tbody>

Your help is much appreciated, thank you.

 

[Aladin Akyurek]

Is A:B >> FN1 and FN2? Is FN3 the look up value?

If yes to both:

=INDEX(B:B,MATCH(E66,A:A,0))

 

[sunvad]

Is A:B >> FN1 and FN2? Is FN3 the look up value?

If yes to both:

=INDEX(B:B,MATCH(E66,A:A,0))

that is probably bad data i gave you but yes you are right, A=FN1, B=FN2, E=FN3 (lookup value).

i have applied your formula in 'F' =INDEX(B:B,MATCH(E2,A:A,0)) but still results in #N/A

 

[Aladin Akyurek]

that is probably bad data i gave you but yes you are right, A=FN1, B=FN2, E=FN3 (lookup value).

i have applied your formula in 'F' =INDEX(B:B,MATCH(E2,A:A,0)) but still results in #N/A

Given:

Row\Col	A​	B​	C​	D​	E​	F​
1​	FN1	FN2			FN3	FN1
2​	DES00007	CZC20601SX			CZC2510LJW
3​	DES00132	CZC2510LH2			CZC2510LK9
4​	DES00274	CZC20601T9			CZC4122L00
5​	DES00293	CZC2510LJK			CZC4122L1J
6​	DES00298	CZC20601VN			CZC4122L0V
7​	DES00311	CZC20601T1			CZC4122L1C
8​	DES00325	CZC20601S6			CZC20601S0
9​	DES00409	CZC20601RP			CZC2097DYK
10​	DES00415	CZC2097DYD			CZC20601TY
11​	DES00431	CZC2510LHS			CZC2184K06
12​	DES00442	CZC2184JZ4			CZC20601RW
13​	DES00452	CZC2097DXS			CZC20601RM

What values (results) are you expecting to see in F2 downwards?

 

[lovesid]

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)

FN1	FN2			FN3	FN1
DES00007	CZC20601SX			CZC2510LJW	#N/A
DES00132	CZC2510LH2			CZC2510LK9	#N/A
DES00274	CZC20601T9			CZC4122L00	#N/A
DES00293	CZC2510LJK			CZC4122L1J	#N/A
DES00298	CZC20601VN			CZC4122L0V	#N/A
DES00311	CZC20601T1			CZC4122L1C	#N/A
DES00325	CZC20601S6			CZC20601S0	#N/A
DES00409	CZC20601RP			CZC2097DYK	#N/A
DES00415	CZC2097DYD			CZC20601TY	#N/A
DES00431	CZC2510LHS			CZC2184K06	#N/A
DES00442	CZC2184JZ4			CZC20601RW	#N/A
DES00452	CZC2097DXS			CZC20601RM	#N/A

<tbody>
</tbody>

Your help is much appreciated, thank you.

The lookup value should be the 1st column in your selection , so to get your wexisting formula working you need to swap the column between Fn1 & Fn2

For example the last row

A:CZC2097DX B:SDES00452

C:

CZC20601RM Now if i take it as A,B,C then in D:= vlookup(C1,A:B,1,FALSE)

<tbody>
</tbody>

 

[lovesid]

Sorry vlookup(C1,A:B,2,FALSE)