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 vote184 views5 answers
Asp.net core linux systemd
Shell/Bash
0 vote126 views1 answer
Mac No module named 'numpy'
Shell/Bash
1 vote135 views1 answer
Truffle hd
Shell/Bash
0 vote146 views1 answer
Cmder find file
Shell/Bash
1 vote152 views1 answer
Get newest version of original in own fork
Shell/Bash
12 votes146 views2 answers
How to tar
Shell/Bash
106 votes128 views6 answers
Undo last commit
Shell/Bash
0 vote156 views1 answer
Kubernetes commands
Shell/Bash
9 votes144 views6 answers
Unable to acquire the dpkg frontend lock (/var/lib/dpkg/lock-frontend), are you root?
Shell/Bash
2 votes148 views1 answer
Ubuntu startup script
Shell/Bash