excuisite1
New Member
- Joined
- Oct 19, 2016
- Messages
- 16
=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
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
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>