MPDK166
04-08-2011, 12:36 AM
LS,
I want to get data from a other sheet then the main sheet when there is a match between two variables (main sheet and sub sheet).
Currently i have got this formula, but how to continue?
=IF(SOMPRODUKT(--(VC!A1:A100=Voorblad!B2))=1;?????????;0)
I want to get data from row of the VC! sheet column B when the result of the match is 1.
e.g.
When Voorblad!B2 matches VC!A35 then I want to get the data from VC!B35.
I want to get data from a other sheet then the main sheet when there is a match between two variables (main sheet and sub sheet).
Currently i have got this formula, but how to continue?
=IF(SOMPRODUKT(--(VC!A1:A100=Voorblad!B2))=1;?????????;0)
I want to get data from row of the VC! sheet column B when the result of the match is 1.
e.g.
When Voorblad!B2 matches VC!A35 then I want to get the data from VC!B35.