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 vote137 views1 answer
How to check process id in linux
Shell/Bash
0 vote127 views4 answers
Download stardocks sdk from nuget package
Shell/Bash
0 vote124 views1 answer
Zsh to bash mac
Shell/Bash
0 vote143 views1 answer
Use local image with minikube
Shell/Bash
0 vote138 views1 answer
How to delete a folder in arch linux terminal
Shell/Bash
2 votes162 views1 answer
'json-server' is not recognized as an internal or external command, operable program or batch file.
Shell/Bash
0 vote138 views1 answer
Web server not running due to lack of necessary permissions in linux nginx
Shell/Bash
18 votes158 views3 answers
Linux how to give permission to folder forever
Shell/Bash
0 vote137 views1 answer
Vue command not found
Shell/Bash
0 vote136 views1 answer
Fuck installation
Shell/Bash