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

1 vote163 views1 answer
Using the 'memory' GSettings backend. Your settings will not be saved or shared with other applications.
Shell/Bash
2 votes178 views1 answer
Get jq command
Shell/Bash
6 votes167 views3 answers
How to know version of tensorflow in linux command line
Shell/Bash
2 votes165 views1 answer
'Cordova/CDVUserAgentUtil.h' file not found
Shell/Bash
0 vote169 views1 answer
Sqlmap enumerate databases for login page
Shell/Bash
-1 vote136 views1 answer
Ubuntu permission deneied
Shell/Bash
0 vote206 views1 answer
Install kubernetess on mac
Shell/Bash
6 votes171 views3 answers
Docker machine install linux
Shell/Bash
3 votes164 views3 answers
Oh my zsh git
Shell/Bash
37 votes194 views5 answers
Git reset hard to remote
Shell/Bash