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 vote133 views1 answer
Nginx: [error] open() "/run/nginx.pid" failed (2: No such file or directory)
Shell/Bash
0 vote156 views1 answer
Install gnome-clocks ubuntu
Shell/Bash
0 vote150 views1 answer
Chromium open new tab linux terminal
Shell/Bash
12 votes153 views1 answer
Flutter doctor android licenses exception in thread main java.lang.noclassdeffounderror
Shell/Bash
0 vote143 views1 answer
How to move one folder back on command promps
Shell/Bash
3 votes144 views1 answer
Save output of command to craible bash
Shell/Bash
1 vote189 views1 answer
Regex match numbers and special characters
Shell/Bash
13 votes134 views5 answers
Checkout remote branch
Shell/Bash
0 vote148 views1 answer
Can't connect to IBus.
Shell/Bash
0 vote148 views2 answers
Jenkinsfile run curl in a function
Shell/Bash