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

4 votes361 views2 answers
Error: snap "gimp" has "install-snap" change in progress
Shell/Bash
0 vote370 views1 answer
How to create docker for wordpress container
Shell/Bash
0 vote346 views1 answer
Delete from transfer.sh
Shell/Bash
0 vote324 views1 answer
Composer preferred-install dist and source
Shell/Bash
4 votes334 views2 answers
Install qt creator ubuntu 20.04
Shell/Bash
16 votes369 views3 answers
How to uninstall yarn npm
Shell/Bash
1 vote373 views1 answer
How do i make a gif from youtube
Shell/Bash
17 votes319 views4 answers
Cmd composer
Shell/Bash
3 votes338 views1 answer
Git existing code to new repository
Shell/Bash
0 vote317 views2 answers
How to download nessus to kali debian 64 bit vm
Shell/Bash