Hi all, a while back one of you gave me an awesome formula that pulls data from sheet 2 based on what was typed in A1 and A2 on sheet 1.
Well I ran into a snag, is there a way we can add a 3rd match in the formula. See the attached file.
I need to pull data from sheet 2 based on what is typed on sheet 1 in cell A1, A2 and A3.
Exp
Sheet 1, report to be printed
A1 = last name
A2 = first name
A3 = month
Sheet 2, data is held here
Need to pull data in column “M”
Thanks for the help
MS Excel 2002 SP3
Windows XP Pro
Bookmarks