Bash vlookup function

# Example usage:
awk 'FNR==NR{a[$1]=$2; next}; {if($9 in a) {print $0, "\t"a[$9];} else {print $0, "\tNA"}}' input_file_1 input_file_2
# This command does a VLOOKUP-type operation between two files using
#	awk. With the numbers above, column 1 from input_file_1 is used 
#	an a key in an array with column 2 of input_file_1 as the match for 
#	the key. Column 9 of input_file_2 is then compared to the keys from
#	input_file_1 and any matches return the associated match from 
#	input_file_1 (here, column 2).

Source: unix.stackexchange.com

Similar codes

0 vote191 views1 answer
Python-swiftclient 3.5.0 uninstall ubuntu
Shell/Bash
4 votes194 views1 answer
Create a new branch from an existing branch stackoverflow
Shell/Bash
7 votes215 views5 answers
Update branch with master
Shell/Bash
0 vote187 views2 answers
Get string after character shell script
Shell/Bash
0 vote185 views1 answer
How to turn off bluetooth in ubuntu 18.04 terminal
Shell/Bash
0 vote195 views1 answer
Remote root directory jenkins centos
Shell/Bash
0 vote185 views1 answer
Cache github credentials ubuntu
Shell/Bash
-2 votes197 views3 answers
Apt install youtube-dl
Shell/Bash
0 vote234 views1 answer
Install solana anchor
Shell/Bash
19 votes239 views3 answers
Start xampp
Shell/Bash