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

8 votes187 views6 answers
Merge master into local branch
Shell/Bash
9 votes328 views4 answers
Revert to a particular commit git
Shell/Bash
0 vote180 views1 answer
Kubernetes get crd and their namespaces
Shell/Bash
0 vote209 views1 answer
Centos install copmposer
Shell/Bash
13 votes194 views2 answers
Find npm version
Shell/Bash
-1 vote181 views1 answer
Rm file from github
Shell/Bash
0 vote200 views1 answer
Check if firebase is installed globally
Shell/Bash
0 vote182 views1 answer
Bin/magento command not found
Shell/Bash
0 vote189 views2 answers
Git already up to date but not
Shell/Bash
23 votes174 views1 answer
Java check jre version
Shell/Bash