VLOOKUP Help

[Guest]

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

 

[Biff]

One way:

=VLOOKUP(A2,'RAW DATA'!A$2$4,MATCH(B2,'RAW DATA'!A$1$1,0),0)

Biff