ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/245507-vlookup.html)

puiuluipui

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!


All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com