| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup over several columns
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/tutorials...-compiled.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup 2 columns | Excel Worksheet Functions | |||
| Lookup across columns | Excel Worksheet Functions | |||
| Lookup Two Columns - Again | Excel Worksheet Functions | |||
| Lookup Two Columns | Excel Worksheet Functions | |||
| Lookup a value using two columns | Excel Worksheet Functions | |||
Threaded Mode
