View original (French)

Copy formulas exactly as they are.

Solved
Fonteclose -  
 Fonteclose -
Hello everyone, my question is how to copy this formula (across multiple cells in the calculation sheet) while keeping the same formula in all the other cells. Apparently, you need to use $ but I can't manage to place it, thank you for your assistance.

Here is the formula below:

=IFERROR(VLOOKUP(D12:D113,'Price List'!A3:B301,2,0),"")

Eric

Configuration: Macintosh / Safari 11.0.2

2 réponses

Réponse 1 / 2
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   4 742
 
Hello,

Your formula doesn't seem functional to me, but this should work for the range D12:D113: 
=IFERROR(VLOOKUP(D12,'Price List'!$A$3:$B$301,2,0),"")

--
Always zen
Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
0