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 vote332 views1 answer
Wget multiple urls from file
Shell/Bash
11 votes300 views2 answers
Open current folder in terminal linux
Shell/Bash
1 vote294 views1 answer
Avrdude: ser_open(): can't open device "/dev/ttyACM0": Permission denied ioctl("TIOCMGET"):
Shell/Bash
0 vote336 views1 answer
Install chrome webdriver node
Shell/Bash
0 vote300 views1 answer
How to install curl on macos
Shell/Bash
0 vote394 views1 answer
Tree command levels
Shell/Bash
0 vote309 views1 answer
Find jpg or png
Shell/Bash
0 vote315 views1 answer
Linux terminal show installed applications
Shell/Bash
11 votes334 views6 answers
Pip install discord.py
Shell/Bash
0 vote304 views1 answer
If file not exists
Shell/Bash