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
puiuluipui wrote:
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! Not with VLOOKUP: that requires the information to fetch to be in the same column, or to the right of the information to match. But there is a way. The following formula should work in "Work sheet" C2: =INDEX(database!$C$2:$G$99,MATCH(work!$D2,database !$D$2:$D$99,0),MATCH(work!C$1,database!$C$1:$G$1,0 )) One you have pasted it there, you can copy C2 and paste anywhere in columns C,E,F and G to get relevant information for those columns as well. If "database" is longer than 99 rows change "$99" in the formula accordingly. |
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 |