Trouble with Vlookup. Simple formula returning value error.

[excuisite1]

=iferror(VLOOKUP(N71:Q79,Monday!N59:Q67,21,FALSE)

Above is the formula I tried to use. It keeps returning #value!

So basically table 2 stays static. But table 1 will have different diameters and different # of welds every day.

All I want is for table 2 to look at table 1, see if any of the diameters match that day. If the diameters match then I want table 2 to update it's # of welds cell with the total welds for that diameter found in Table 1.

Table 1: Diameter (N59:Q67)
Table 1 & 2: # of Welds (column 21)
Table 2: Diameter (N71:Q67)

Table 1

Diameter	# of Welds
2"	15
4"	2
8"	8

<tbody>
</tbody>

Table 2

Diameter	# of Welds
2"
3"
4"
5"

<tbody>
</tbody>

 

[HotRhodium]

Good deal let me know if you see any issues I threw it together a couple days back so if there is any contingency I did not think of I will update. Also feel free to use negative offsets for x or y

 

[Gerald Higgins]

Or how about this
=iferror(VLOOKUP(N71:N79,Monday!N59:Q67,4,FALSE)

 

[excuisite1]

In reference to
=iferror(VLOOKUP(N71:N79,Monday!N59:Q67,4,FALSE)

this formula does not work.

 

[Gerald Higgins]

In what way does it not work ?