Hi everyone,
I don't know if maybe I'm off-topic but I haven't found a SHEET group so I post here, don't blame me.
I have this expression:
=VLOOKUP(A2; Ingredientes!A2:D30; 4; FALSE)
I don't know if it also exists in Excel, in the case of Sheet it serves to Search the Tab named "ingredientes" for a specific content (A2) in the cell rank A2 to D30...
It works perfectly, A2 is a dynamic cell that is chosen via drop down menu, the function searches for that word in the sheet and returns me the value of the fourth column (Id 4)..
Now, to duplicate the formula I click as usual on the bottom right square and drag to the cells below for duplicate the formula... but, unexpectedly, as well as increasing the value of A2 (a3, a4, a5.. ) it also increases the rank values... A2-D30 which should instead remain fixed...
Is there any way around this problem? Thank you.
DigiART
Bookmarks