Vlookup formula that references the row you are on

[Locopete99]

Guys I have a spread sheet thats got 3 cells in question.

Cell 1 has my information, cell 2 has my main formula that I plan to drop down over about 2k lines. Cell 3 has an option formula.

So cell 1 reads: Finestra vetro trasparente TC-TE 18W (GX24q-2) AMM. 3,00

Cell 2 has a formula that says "IF(COUNTIF(H50,"*LED*"),VLOOKUP(B50,$AA$10:$AH$111,7,FALSE),VLOOKUP(B50,$AA$10:$AH$111,8,FALSE))

Cell 3 has a formula =IF(COUNTIF(H50,"*GX24Q-2*"),"TC-TE 18W (GX24Q-2)",IF(COUNTIF(H50,"*GX24Q-3*"),"TC-TE 26W (GX24Q-3)"," "))

The problem is, where I will be pulling down the formala in cell 2 over multiple lines, I need to be able to rewrite the formula in cell 3 so that it always references the row cell 2 is on.

Im tryin to do it this way so i dont have to have it 2k+ times on my spreadsheet.

Can anyone help??

[Mazzaropi]

Locopete99 Good Morning.

Itīs a little confused.

May you attach an example spreadshhet here pointing exactly what you have and what you desire as result?

Have a nice day.

[ChemistB]

Not sure what you are trying to anchor but the "$" will anchor a row or a column
For example, if you use H$50, and drag down, the 50 will not change. $H$50 will lock in both the row (when dragging down) and the column (when dragging across)
Is that what you are looking for?

[dilipandey]

Hi Locopete,
Your thread title says

Vlookup formula that references the row you are on

and for this you can use formula as = row()
and this will always reference the row you are on

If you have other doubts, upload a sample workbook with your expected results. thanks.

Regards,
DILIPandey
<click on below * if this helps>

[Locopete99]

Thanks guys I'll see if I can use that.

[dilipandey]

Okay.. and if still stuck, upload the sample workbook this time



Regards,
DILIPandey
<click on below * if this helps>