DB problem

[dwagner13 0]

My league combines WR and TE. In doing so, when I used DB and selected TE for position for Tony Gonzalez, there were no player names listed, no big deal, I just changed the position to WR and there they were. The problem is that when Gonzalez is selected, his team and bye columns show #N/A.

 

The formula is looking for him in the WR_2_detail column, but he is not there due to the fact that he is in the TE_2_detail column. If we set it up to combine WR/TE shouldn't he be imported to the WR column and not the TE column? Any easy way to fix this?

 

Thanks,

 

Doug

[Mike MacGregor 20]

Hi Doug. After you've selected his name from the WR drop-down, switch the position back to TE. I didn't realize this quirk in Buddy before so I'll have to address this for next season.

[dwagner13 0]

I did that to make it work. I just wasn't sure if there was an easy way to extend the WR_2_detail column easily.

 

This also affects the "Who Won" tab that I created (following a previous poster)

 

=IF(V45="","",VLOOKUP(V45,INDIRECT(CONCATENATE($B45,"_Detail")),4,0))

 

returns #N/A. If I change it to

 

=IF(V45="","",VLOOKUP(V45,INDIRECT(CONCATENATE($B44,"_Detail")),4,0))

 

it calculates the correct projected points.

 

Just thought you might want to know that as well.

 

Doug