Check Box (Form Controls)

[J G]

Hello,
This file is designed to be a dynamic staffing analysis. Users are supposed to input data in the gray boxes. User check the boxes to select difference options for the position. However, I'm having trouble with the first check box in each set of three. For some reason when the first box is checked, the formulas return values as if the third box is checked. However the second and third check boxes in the series work as designed.

Any ideas on this problem?

Thanks,
J G

 

[vletm]

Have You tried to use range_lookup-parameter? set to FALSE
Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

range_lookup

A logical value that specifies whether you want this function to find an exact match or an approximate match.

• If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned.
• If FALSE, this function will find an exact match. If one is not found, the error value #N/A is returned.

 

[J G]

Excellent, thanks!