Vlookup
=INDEX('database sheet'!C:C,MATCH(D2,'database sheet'!D:D,0))
Regards,
Stefi
€˛puiuluipui€¯ ezt Ć*rta:
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!
|