I need help with a VLookup Issue. When I copy a cell from one workbook to another, Vlookup return a #REF!. See below:
This is the formula in the cell I copy workbook Pricelist SLA.xls
=VLOOKUP(A313;Input!$C$63:$L$83;10;FALSE)
This is the formula when I paste it into workbook Pricelist2.xls
=VLOOKUP(#REF!;'[Pricelist SLA.xls]Input'!$C$63:$L$83;10;FALSE)
Is it possible to copy the cell without getting the #REF! error?
This is the formula in the cell I copy workbook Pricelist SLA.xls
=VLOOKUP(A313;Input!$C$63:$L$83;10;FALSE)
This is the formula when I paste it into workbook Pricelist2.xls
=VLOOKUP(#REF!;'[Pricelist SLA.xls]Input'!$C$63:$L$83;10;FALSE)
Is it possible to copy the cell without getting the #REF! error?