Thread: vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default vlookup

Hi, i have this situation:
database sheet:
C D E F G
den ref cod gr price
mask ch09 0838 2 3.4

Work sheet:
C D E F G
den ref cod gr price

The code will be in C2.
In D2 i will select ch09 from dropdown, and a cell back, in C2 i need the
code to retrieve mask. If i select another "ref" in D, then the code to
retrieve corresponding data from database sheet
Can this be done?
Thanks!