=VLOOKUP(A53,'Tab(4Y-R)'!A24:AU157,COLUMNS('Tab(4Y-R)'!A24:A24)+1,FALSE())
=VLOOKUP(A53,'Tab(4Y-R)'!A24:AU157,ROWS('Tab(4Y-R)'!A24:A24)+1,FALSE())
=ROWS(B$4:B4)
Showing posts with label Dynamic Column. Show all posts
Showing posts with label Dynamic Column. Show all posts
Friday, February 16, 2024
Increment the cell in Vlookup when dragging horizontally in Excel
Excel VLOOKUP with Dynamic Column Reference:
=VLOOKUP($B16,$B$4:$D$13,COLUMNS($B4:B4)+1,0)
=VLOOKUP($B16,$B$4:$D$13,COLUMNS($B4:C4)+1,0)
Subscribe to:
Posts (Atom)