Aug 17 2021 08:37 AM
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!
Aug 17 2021 08:47 AM
SolutionAug 17 2021 08:55 AM
@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?
Aug 17 2021 10:53 AM
Aug 17 2021 10:54 AM
Aug 17 2021 10:56 AM
Aug 17 2021 08:47 AM
Solution