Forum Discussion
Solved
Vlookup does not work when based on formula
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 t...
- If possible plz share the WB with us since the screen shot is not enough to understand the issue !!
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?
It is indeed the 25th column in the sheet, but the 2nd in the name range... Duh! Thanks!
- Perhaps you can remark the "best answer" 🙂