Search Results

Hi, see if this works:
awk -F'\t' '
NR==FNR {
if(!($1 in L))
L[$1]=$2
R[$1]=$3
next
}
{
print ($2>=L[$1] && $2<R[$1])?$4:"NA"
}
' file1 file2

Yes. How about posting a decent, representative sample of your data including gaps? So proposals given could be tested against samples reflecting reality?