Search Column For Date - Extract Data to workbook #2 1

[Funkymatt]

Worksheets:

Worksheet 1 Data
Cell A1 = always displays the current date
Cell B4 = 1 Month Rate (I need to pull from WS #2)
Cell B5 = 2 Month Rate (I need to pull from WS #2)
Cell B5 = 3 Month Rate (I need to pull from WS #2)
Cell B5 = 6 Month Rate (I need to pull from WS #2)
Cell B5 = 12 Month Rate (I need to pull from WS #2)

Worksheet 2 Data
Row X (where X is the manually keyed data for today)
Cell AX = Today's Date
Cell BX = 1 Month Rate
Cell CX = 2 Month Rate
Cell DX = 3 Month Rate
Cell EX = 6 Month Rate
Cell FX = 12 Month Rate


Question:
Is it possible to enter a forumla in Worksheet1 that uses the uses the current date in Cell A1 to lookup, and pull, the Monthly rates from worksheet 2?

 

[SkipVought]

Hi,

You ought to be able to use VLOOKUP.
[tt]

Cell B4 =vlookup(A1,Sheet2!$a$1:$F$9999,2,false)
Cell B5 =vlookup(A1,Sheet2!$a$1:$F$9999,3,false)
Cell B6 =vlookup(A1,Sheet2!$a$1:$F$9999,4,false)
Cell B7 =vlookup(A1,Sheet2!$a$1:$F$9999,5,false)
Cell B8 =vlookup(A1,Sheet2!$a$1:$F$9999,6,false)
[/tt]
or whatever your range is (Sheet2!$a$1:$F$9999)



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Funkymatt]

Thanks so much skip....it worked beautifully!