M
MichaelRobert
How can I use the Validation Ref # to describe the cell contents to be
'looked up'
My LOOKUP formula is:
=IF(B7="Gray",LOOKUP(B17,Accessories!A22:C24,Accessories!B22:B24),LOOKUP(B17,Accessories!A22:C24,Accessories!C22:C24)) [CTRL-SHIFT-ENTER]
B17 contains a text string provided by Validation that does not match the
nomenclature in the LOOKUP Table. (Validation returns REF# = '1-4" tube' or
REF# = '2-4" tubes'. But the LOOKUP lists 4")
I can deal with the quantities (1 or 2) elsewhere, but I need help in
figuring out how to modify the 'B17' component
Thanks.
Mike
'looked up'
My LOOKUP formula is:
=IF(B7="Gray",LOOKUP(B17,Accessories!A22:C24,Accessories!B22:B24),LOOKUP(B17,Accessories!A22:C24,Accessories!C22:C24)) [CTRL-SHIFT-ENTER]
B17 contains a text string provided by Validation that does not match the
nomenclature in the LOOKUP Table. (Validation returns REF# = '1-4" tube' or
REF# = '2-4" tubes'. But the LOOKUP lists 4")
I can deal with the quantities (1 or 2) elsewhere, but I need help in
figuring out how to modify the 'B17' component
Thanks.
Mike