Vlookup does not work when based on formula

[Elva_Tanguerre]

Hello, my vlookup does not work when the value to lookup is the result of a formula. In the example below, the Transfert Detail column is the result of a vlookup. The subsequent Vlookup in Campaign that references the AK column in the following formula gives me a #REF!:

=VLOOKUP((AK3),Transfer,25,FALSE)

How can I fix this? Thanks!

[#2 · Accepted solution]

If possible plz share the WB with us since the screen shot is not enough to understand the issue !!

[#3]

@Elva_Tanguerre First of all, you can get rid of the brackets surrounding AK3. Then the #REF error suggests that you are attempting to return a column that does not exist in the lookup range. The lookup range, in your case, is a named range called "Transfer". Are you sure it has the Transfer Detail in the first column and that is has at least 25 columns?

[#4]

Thanks, but Riny_van_Eekelen has solved it.

[#5]

It is indeed the 25th column in the sheet, but the 2nd in the name range... Duh! Thanks!

[#6]

Perhaps you can remark the "best answer" :)