Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
I have raw data that I want to pull into my main sheet. It looks like the
following. What is best formula to us so it auto picks the proper column in rawdata? Thanks. Main Sheet ID Date Info 14 01/31/06 23 02/28/06 34 03/31/06 Raw Data ID 01/31/06 02/28/06 03/31/06 14 info info info 23 info info info 34 info info info -- thanks, mc |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
One way:
=VLOOKUP(A2,'RAW DATA'!A$2:D$4,MATCH(B2,'RAW DATA'!A$1:D$1,0),0) Biff "dallin" wrote in message ... I have raw data that I want to pull into my main sheet. It looks like the following. What is best formula to us so it auto picks the proper column in rawdata? Thanks. Main Sheet ID Date Info 14 01/31/06 23 02/28/06 34 03/31/06 Raw Data ID 01/31/06 02/28/06 03/31/06 14 info info info 23 info info info 34 info info info -- thanks, mc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and its properties | Excel Worksheet Functions | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |