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 that references the AK column in the following formula gives me a #REF!:
=VLOOKUP((AK3),Transfer,25,FALSE)
How can I fix this? Thanks!
- If possible plz share the WB with us since the screen shot is not enough to understand the issue !!
5 Replies
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" 🙂
- If possible plz share the WB with us since the screen shot is not enough to understand the issue !!
- Thanks, but Riny_van_Eekelen has solved it.
