|
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! |
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! |
| All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com