Oline IT:Blog
Innovation Technology
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)
=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)
Older Posts
Home
Subscribe to:
Posts (Atom)
Extract Domain from email in Excel or Google sheet
=TEXTAFTER( A2 , "@") or, =MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))
Office 2019 Activation without Product Key using CMD
Put the following code in a TXT file and save as "file.cmd" then run the cmd file as administrator. @echo off title Activate Micr...
PowerMTA Multiple Virtual PMTA config file
# $Id: config 2015-03-24 16:00:00 Jack $ # Sample PowerMTA configuration file # PowerMTA Multiple Virtual PMTA config file sample # # E-mai...
install PowerMTA on the server
We can install PowerMTA on the server. rpm -ivh /home/PowerMTA-4.0r6.x86_64.rpm You will see the output like this Preparing... #############...