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 vote234 views1 answer
How to download youtube vides on linux
Shell/Bash
7 votes246 views2 answers
Git reset change in one file
Shell/Bash
0 vote236 views1 answer
Wget --spidedr
Shell/Bash
0 vote243 views1 answer
Ubuntu restart network manager when ping is low
Shell/Bash
0 vote235 views1 answer
Shell save variable
Shell/Bash
0 vote226 views1 answer
Terminator linux is not start
Shell/Bash
1 vote221 views1 answer
Kill jobs fg
Shell/Bash
18 votes244 views4 answers
Install yarn in mac
Shell/Bash
0 vote241 views1 answer
Git force sync with remote
Shell/Bash
0 vote242 views1 answer
Libodbc1 2.3.7 ubuntu
Shell/Bash