Lookup

[Teona]

In Column A I have a list of statement codes, in column C I have a list of statement codes too and in column D I have corresponding dates for each code. I try to lookup all apropriate dates and put in B column.
I tried the following two forula and neither one worked, it did not give the exact match.
1.=LOOKUP(A2,$C$2:$C$7412,$D$2:$D$741)
2.=VLOOKUP(A2,C2:D7412,2,FALSE)
Could you help me and tell what I am doing wrong?

P.S. I don't know if it matters, but anyways... In column A there are some codes that are not in column C and vice versa.

Thanks you!

 

[diddi]

try the Match() function

 

[CharlesChuckieCharles]

From your description
option 2 looks credible

are the statement codes numbers or text if text does one or otherside have spaces (leading)
does .=VLOOKUP(A2,C2:D7412,2,TRUE)
produce a better result

 

[Teona]

CharlesChuckieCharlesCodes are mix of number and text and they do not have spaces.
with True, there are less N/A, but it does not looks up the exact matches, I get the inaccurate result with it.
Instead of A2 I even tried to type the code the same way it as in Column A and Column C, and it still turned into N/A.

 

[Teona]

Found the reason!!!! YaY
In column A I have 0s, while in column C there are Os.
OMG, it almost drove me nuts.