VLOOKUP Not working

[Faiek]

Hey All,
I have made a VLOOKUP Code to find a value on another page. It works with one value and shows the correct "Description" and "Cross Value Number". It is suppost to work Vise-versa but It does not, the only thing altered is the columns number. The code for the working one is:

=VLOOKUP(C4, Crossreftable, 2, FALSE)

For the non-working one is:

=VLOOKUP(C4, Crossreftable, 1, FALSE)

I'd appreciate if anyone can help with this matter.

Thanks,
Faiek

 

[hiker95]

Faiek,

Your Crossreftable contains two columns "Description" and "Cross Value Number".

With:
=VLOOKUP(C4, Crossreftable, 2, FALSE)

You are looking up what is in C4, which is in the "Description" column, and returning the 2, which refers to the "Cross Value Number" column.

This will work as long as C4 contains a value in the "Description" column.


With:
=VLOOKUP(C4, Crossreftable, 1, FALSE)

This would return an error.

You would have to use Index with Match to search the "Cross Value Number" column, and return the value in the "Description" column.


To help to clarify the above, can we have a screenshot of the "Crossreftable".

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[hiker95]

Faiek,


Maybe this will help:

Excel Workbook
	C	D	E	F	G	H	I
1						Crossreftable
2						aaa	2
3						bbb	3
4	ccc	4				ccc	4
5	4	#N/A				ddd	5
6	4	ccc
7
Sheet1

 

[hiker95]

Faiek,

Excel Workbook
	C	D	E	F	G	H	I
1						Crossreftable
2						aaa	2
3						bbb	3
4	ccc	4				ccc	4
5	ccc	ccc				ddd	5
6	4	#N/A
7	4	ccc
8
Sheet1

 

[Faiek]

Thanks So Much! Got it working, Your Expertise is much appreciated.

 

[hiker95]

Faiek,

You are very welcome. Come back anytime.

The following INDEX MATCH formula should be easier to use.

Excel Workbook
	C	D	E	F	G	H	I
1						Crossreftable
2						aaa	2
3						bbb	3
4	ccc	4				ccc	4
5	ccc	ccc				ddd	5
6	4	#N/A
7	4	ccc
8
Sheet1