View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
H H is offline
external usenet poster
 
Posts: 57
Default Multiple Choices in a cell with HLOOKUP

Column A- Is an Item number that you enter manually
Column B - has an H lookup formula that refers to the number entered in
column A
(Column A is an item number and when entered in Column B the items
description comes up)
I would like column C to have a drop down menu that only has the color
choices that are available for that item.

I'm stuck on column C. Can you do an HLOOKUP formula refering to another
cell that contains an HLOOKUP formula?

Any help would be appreciated.
Thank you
--
-H