S
Sander Nagtegaal
I'm trying to have a lookup over several columns
situation
sheet 1
A B C
56 110 50000
56 120 10000
56 130 5000
57 110 30000
57 120 10000
57 130 5000
sheet 2
A B C D
56 110 0000
56 110 0001
56 120 0000
56 120 0001
I need value C from sheet 1 put into column D in sheet 2 no matter wath the value is in column C of sheet 2
How do I do this (exact file is 25000 lines so copy/paste isn't a real option)
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# Specification Compiled CHM Help File
http://www.eggheadcafe.com/tutorial...4c-920b6365063b/c-specification-compiled.aspx
situation
sheet 1
A B C
56 110 50000
56 120 10000
56 130 5000
57 110 30000
57 120 10000
57 130 5000
sheet 2
A B C D
56 110 0000
56 110 0001
56 120 0000
56 120 0001
I need value C from sheet 1 put into column D in sheet 2 no matter wath the value is in column C of sheet 2
How do I do this (exact file is 25000 lines so copy/paste isn't a real option)
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# Specification Compiled CHM Help File
http://www.eggheadcafe.com/tutorial...4c-920b6365063b/c-specification-compiled.aspx