I am not very good with using the INDEX function which is what I think I have to do here.
In Worksheet 1 have a column of dates in C, Column of Names in F. In worksheet 2, I have these same names in Col A, and the Dates in Col C, and a value in Col O. What I need to do in the first worksheet, is look at the Date, and Name, go to Worksheet 2, find the same Date and Name, and return the value form Col O, and place it in Col G. I don't remember being able to use VLOOKUP to find 2 different criteria. Thanks in advance for any help!
Note: I realize in Sheet 2, the name is before the date, not sure if that matters?
Bookmarks