I'm still not quite sure what you have. Is it something like this in
sheet1:

Date1 Date2 Date3 etc
Business Line 1 data data data
Business Line 2 data data
Business Line 3 data
Business Line 4 etc

And on this sheet you want to find the "data" that corresponds to a
Business Line and a Date?

Then in your second sheet you have an arrangement like:

Business Line 1 Date1 xx
Business Line 1 Date2
Business Line 1 Date3
etc for other dates
Business Line 2 Date1
Business Line 2 Date2
etc
Business Line 3 Date1
etc etc

and you want xx to be the data from sheet1 which corresponds to
Business Line 1 and Date1 ??

If not, please put me on the right track.

Pete

Shannon wrote:
Hi Pete,

The data I am using has a series of dates horizontally that I reference,
there are "lines of business" vertically on the left side of the sheet. In a
different workbook I had the dates and lines of business vertically. What I
am trying to do the use the data in the intersecting cell of the first
workbook to populate a cell in the other workbook. So I thought, if I nest a
vlookup, referencing the date and then reference the line of business I could
direct the data. Does that make the dog bark?

"Pete_UK" wrote:

I thought it was barking ... <g

Yes, it is possible to nest VLOOKUPs, and you can also use an
INDEX/MATCH combination to achieve the same.

Is it possible to post a few more details of how your data is
structured and exactly what you want to achieve?

Pete

Shannon wrote:
Hello,
Say I was wondering if it is possible to nest vlookup statements. I am in
one workbook and I am trying to reference a date and then reference a
different cell, if both cells match the reference cells then populate the
data from the intersecting cell. It does work with If/Then, but it seems
like vlookup would be much more efficient. Am I looking up the wrong
proverbial tree?