Function RECHERCHEV does not work

Hello everybody,

I come with another question about RECHERCHEV, please help me

I have two excel files that are in different workbooks (and therefore two different directories), I want to link two excel sheets, each from one of the workbook

on the first sheet I have the column names of the countries in the second sheet I have a column of names of countries (column number 1), and another column that says if the country has been treated or not (column number 40)
so I want to check the name of already selected on the first sheet countries, then search column 1 of the second sheet, and put the value "already treated or not" that appear on the column number 40 on the second sheet.

I mentioned this as well, but apparently related it does not work at all

Please Login or Register  to view this content.

= RECHERCHEV (B3, Sheet2 A3: AN240, 40!)

Please Login or Register  to view this content.

.



Thank you so much

Hi Olly,

I did like you said

=VLOOKUP(B7,'K:\System\DATABASE\D2014\[tototo.xlsx]work process 2014'!$A$3:$AN$240,40,FALSE) but it still doesn't work

No I have no remarq and no error, it appears like

Please Login or Register  to view this content.

=VLOOKUP(B7,'K:\System\DATABASE\D2014\[tototo.xlsx]work process 2014'!$A$3:$AN$240,40,FALSE)

Please Login or Register  to view this content.

But nothing is happen, like as if that is not a formula

This time, I have an error message

ok Olly and XOR

XOR you had right, I changed the format cell in General, but now i have an error message #N/A

Hi XOR,

I really apologize to not upload the file, I woul like to do it earlier but the button "attach the file" was hidden because of Mozilla, Now I just used explorer and it appears

So, please find attached my file, with the too sheets (sheet1 and sheet2)

In reality, the two sheets are in two different excel workbooks

Thank you and sorry againfichier_hebergeur.xlsx

Hi All,

I come back again for the same question, I hadn't found the solution yet!
Pease HELP me

XOR, I don't understand your answer, by the VLOOKUP I am looking for the 40th column in the second sheet (the column containing wanted information), so it's normal than the VLOOKUP is referencing column 40.

I put today the formula, VLOOKUP(B3,'K:\System\DATABASE\D2014\[tototo.xlsx]work process 2014'!$A$3:$AN$240,40,FALSE)
and the $A$3 is highlighted

Really I don't know where is the problem

Hi All,

I come back again for the same question, I hadn't found the solution yet!
Pease HELP me

XOR, I don't understand your answer, by the VLOOKUP I am looking for the 40th column in the second sheet (the column containing wanted information), so it's normal than the VLOOKUP is referencing column 40.

I put today the formula, VLOOKUP(B3,'K:\System\DATABASE\D2014\[tototo.xlsx]work process 2014'!$A$3:$AN$240,40,FALSE)
and the $A$3 is highlighted

Really I don't know where is the problem

AN ENORMOUS THANKS To you martindwilson,
This once The VLOOKUP is ok
the Steps you have enumerated are exactly what I needed, and without your solution, I couldn't guess them!

I am really grateful, and for sure for all others who tried to help me

Just one thing, when I kept "False" in the VLOOKUP formula, The formula didn't function

Thank you again

Yes I have already tried Recherchev, Faux, but My Excel software is on English version, it does not recognize Recherchev

Thank you

Good morning everybody,

VLOOKUP it was ok only for some cells but not for others : for some cells I have the information if the file had been processed or not, but for the majority of others, I have only "0" as value instead of "Done" or "ONGOING" which are clearly appeared as values in the second sheet of the TOTOTO file.

I retype the VLOOKUP formula I have in my file VLOOKUP(B3,'K:\System\DATABASE\D2014\[tototo.xlsx]work process 2014'!$A$3:$AN$240,40)
if I add "FALSE" at the end of the formula, all my values become "#NA"

Thank you

Thank you martindwilson for this remark

All my values are written in the same way, even I copied exactly some values in a3:a240 and pasted them in the B column in the first file. But the same result, with "False" in the VLOOKUP Formula, I obtained #N/A for all cells, without "False" I obtained the right value but only for few cells.

This time all thing is ok

Thank you martindwilson!