Vlookup incorrect results

[Liranl]

Hello,
I have a problem with VLOOKUP function and I am looking for a workaround.

SheetA I have a column of business names and another column of the category.
SheetB has a list of credit card transacdtions and a column of categories - The results obtained from incorrect results from SheetA...

TNX

 

[Dannyh1]

Hi,

Can you post you're formula (I imagine you are missing a "FALSE")

 

[Arul.rajesh]

Welcome to the board.

Alternatives for VLookup is a combination of index and match, which is even more confusing than VLookup. Try reading the Help in Excel on VLookup it is farly comprehensive. Read about relative references and absolute references.

 

[Liranl]

I am using a Flase (0) in the furmula...

It just a very long Table of data to vlookup from...

 

[Dannyh1]

Can you post formula?

 

[Liranl]

This is the furmula Im using :

=IFERROR(VLOOKUP(B1,Categories,2,0),"ERR")

Categories = Tables of Data in SheetA

 

[Arul.rajesh]

select "categories" in your formula hit f9 and post the result please

 

[Liranl]

Welcome to the board.

Alternatives for VLookup is a combination of index and match, which is even more confusing than VLookup. Try reading the Help in Excel on VLookup it is farly comprehensive. Read about relative references and absolute references.

Tnx I will try