Problem with Vlook up formula

[majhar420]

I put the the "vlookup" formula in customer Name Column. but it show

"#N/A"error

<tbody>
</tbody>

​

 

[gaz_chops]

If you want an answer you need to provide more info.

 

[majhar420]

Here i attach my work book.


https://drive.google.com/file/d/0B_JDklpuHaA9ckxjQlJQSFpiSW8/view?usp=sharing

 

[GerryZ]

I put the the "vlookup" formula in customer Name Column. but it show

"#N/A"error

<tbody>
</tbody>

​

try:
=INDEX($H$2:$H$10,MATCH(B2,$I$2:$I$10,0))
let me know!

 

[majhar420]

OK.it works .but why vlookup formula does not work here.

 

[GerryZ]

OK.it works .but why vlookup formula does not work here.

Hello I'm glad the formula Workks
The VLOOK works only if the value that you search is located on the lefft of the table
in your case if the value was in Column H (left of the table) the VLOOKUP would work but in you case the value was in the middle of the table (column I)
So if you wnat use VLOOKUP you need to move column H to Column I
like this IFERROR(VLOOKUP(B2,$H$2:$K$10,2,0),"")

Book1
	H	I	J	K
1	MOV_ORDER_NO	CUSTOMER_NAME	MOVE_WAREHOUSE_ORG_NAME	REGION_NAME
2	MO/SCOU/426733	M/S Md. Alamgir	Daudkandi Ghat	Comilla
3	MO/SCOU/426713	M/S Saudia Traders	Daudkandi Ghat	Comilla
4	MO/SCOU/430378	Mannan Traders	Daudkandi Ghat	Comilla
5	MO/SCOU/431383	Mannan Traders	Daudkandi Ghat	Comilla
6	MO/SCOU/436771	A.R Traders	Daudkandi Ghat	Noakhali
7	MO/SCOU/432962	Abedin Traders	Daudkandi Ghat	Noakhali
8	MO/SCOU/426697	Abu Naser & Sons	Daudkandi Ghat	Noakhali
9	MO/SCOU/431480	Abu Naser & Sons	Daudkandi Ghat	Noakhali
10	MO/SCOU/426715	Amin & Sons	Daudkandi Ghat	Noakhali
Truck Wise Trip

 

[GerryZ]

Anyway you can improve your first formula with IFERROR function to avoid to see #N/A
=IFERROR(INDEX($H$2:$H$10,MATCH(B2,$I$2:$I$10,0)),"")
let me know!

 

[majhar420]

Thanks.

 

[AlKey]

Here a modified VLOOKUP formula that should work for you

=VLOOKUP(B2,CHOOSE({1,2},$I$2:$I$10,$H$2:$H$10),2,0)

 

[GerryZ]

You are welcome and thank you for your feedback!