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 vote187 views1 answer
Restart ubuntu 18.04 server
Shell/Bash
0 vote185 views1 answer
App-crashed
Shell/Bash
1 vote141 views1 answer
How to tell ping to exit after a specified number of ECHO_REQUEST packets
Shell/Bash
10 votes177 views2 answers
Uninstall packages linux terminal
Shell/Bash
0 vote170 views1 answer
Filetype exfat not configured in kernel
Shell/Bash
0 vote202 views1 answer
Download latest stable solc ubuntu
Shell/Bash
0 vote181 views10 answers
Close app with terminal
Shell/Bash
0 vote192 views1 answer
Awk or
Shell/Bash
0 vote179 views1 answer
Debian buster add ip alias cli
Shell/Bash
1 vote224 views1 answer
Could not find expected browser (chrome) locally. run npm install to download the correct chromium
Shell/Bash