I've tried looking around but what I found was looking up within the same file or combining columns with exact matches. Whereas I would not have exact matches and right now trying to combine these two codes is above my skill level. Basically I need to add an extra column to include the gene name based chromosome position and grabbing the gene name based on the range of the gene within another file. I know `awk` is my best bet possibly with `FNR==NR`.

File1 looks like this, where `$1` is chromosome, `$2` is position, the rest of the columns are sample coverage across that position:

```
chr1H   49525   47  41  60  74  93  34  117 
chr1H   49526   48  41  62  74  94  34  118 
chr1H   53978   48  40  61  73  94  33  117 
chr1H   53979   48  40  62  72  94  33  116 

```

File2 looks like this, where `$1` is the chromosome, `$2` is the start of the gene `$3` is the end of the gene and `$4` is the gene name:

```
chr1H   49525   49772   gene1
chr1H   50194   50649   gene2   
chr1H   53978   54323   gene3   
chr1H   76743   77373   gene4

```

Either over writing or making a new file to end up with a file that looks like this:

```
chr1H   49525   47  41  60  74  93  34  117 gene1
chr1H   49526   48  41  62  74  94  34  118 gene1
chr1H   53978   48  40  61  73  94  33  117 gene3
chr1H   53979   48  40  62  72  94  33  116 gene3

```

Right now my code looks like this but I'm not sure how I specify the files (right now I've put in file1 or 2 so you know what my thinking is). So that the chromosomes match in both files and the position in the coverage file is between a range within start and end positions within the second file, then printing the entire line from file1 and the gene name from file2:

```
awk '{ if (file1$1 == file2$1 && file1$2 >= file2$2 && file1$2 <= file2$3) print file1$0, file2$4 }' file1 file2 > file3

```

Thanks for any help!