ExcelBanter - VLOOKUP Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP Help (https://www.excelbanter.com/excel-worksheet-functions/114184-vlookup-help.html)

dallin

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

Biff

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

All times are GMT +1. The time now is 03:55 AM.