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 views1 answer
Gh-pages-clean
Shell/Bash
0 vote169 views1 answer
Artisan route list naem
Shell/Bash
24 votes176 views2 answers
Setup commandline vscode in mac
Shell/Bash
1 vote177 views1 answer
Install pylatex with dependency
Shell/Bash
1 vote200 views1 answer
How to remove a plugin from ionic project
Shell/Bash
0 vote189 views1 answer
Afficher l'heure .bat
Shell/Bash
0 vote183 views1 answer
Git global settings ssh
Shell/Bash
2 votes139 views1 answer
How to change port apache2 ubuntu
Shell/Bash
0 vote171 views1 answer
Clock skew detected github
Shell/Bash
28 votes172 views5 answers
Add-apt-repository command not found
Shell/Bash