infiniti7181
asked on
Button Menu vlookup help
Hello Guru's,
I am trying to make a similar sheet like attached for different format . My question is how does the button type system works (CAT1 , CAT2 etc ). I know the concept of vlookup and its format , lets say for eg: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Appreciate your kind help and support to provide me advise.
Regards,
SID
t-eg3.xlsx
I am trying to make a similar sheet like attached for different format . My question is how does the button type system works (CAT1 , CAT2 etc ). I know the concept of vlookup and its format , lets say for eg: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Appreciate your kind help and support to provide me advise.
Regards,
SID
t-eg3.xlsx
ASKER
Thanks , could you please clarify this point also
As per cell B8 , i saw this function statement , VLOOKUP(A8,DB!B3:U19,$B$5* 4-2,FALSE)
what is $B$5*4 -2 , i understood on the cell B5, there were five options , then why it is shown B5* 4 -2 ?
REgards,
SID
As per cell B8 , i saw this function statement , VLOOKUP(A8,DB!B3:U19,$B$5*
what is $B$5*4 -2 , i understood on the cell B5, there were five options , then why it is shown B5* 4 -2 ?
REgards,
SID
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So first you have to fix the excel file to work properly that if you manually input a number in B5, it would show the correct values in the table below. After that, add the radio buttons (and give them a proper name), then link it to B5. Have your table react to numbers starting from 1 (as the cell will only be 1, and up, depending on how many buttons you add)