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 vote137 views1 answer
Como instalar pandoc en ubuntu
Shell/Bash
0 vote122 views1 answer
Important linux command
Shell/Bash
14 votes165 views1 answer
Down last migration laravel
Shell/Bash
0 vote132 views1 answer
ModuleNotFoundError: No module named 'slack'
Shell/Bash
13 votes134 views6 answers
Composer remove package
Shell/Bash
0 vote139 views1 answer
He user limit on the total number of inotify watches was reached; increase the fs.inotify.max_user_watches sysctl\n'
Shell/Bash
0 vote133 views1 answer
Cant install cython buildozer
Shell/Bash
0 vote170 views1 answer
ConfigurationError: The "dnspython" module must be installed to use mongodb+srv:// URIs
Shell/Bash
13 votes133 views3 answers
Check disk space folders linux
Shell/Bash
0 vote123 views1 answer
Ubuntu restart network manager when ping is low
Shell/Bash