Hello,
I am trying to take two different spreadsheets and based on 3 conditions place a value into a cell. The criteria would be to match MRN# in Master Sheet to MRN# in Lab Values and if true, then check if month and year are true and do a vlookup to place the lab value in the Master Sheet for that MRN# under the correct Month/YearScore column. I have tried several combinations of IF(AND(), VLookup) but always get #N/A. I have attached a sample spreadsheet with two sheets that represent my data sets. Any suggestions would be appreciated.
Bookmarks