Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |