Forum Discussion
Vlookup 2 worksheeets 1 criteria multiple up to 3 matches for a unique identifier
Single workbook worksheet 1 is all Ed visits during a specified time Worksheet 2 is all antibiotics prescribed during the same time period up to 3 antibiotics Rx'd in a visit. Formula is: {=IFERROR(IN...
Formula looks correct from syntax point of view. Perhaps incorrect using of ROW(), COLUMN() - hard to say without the file.
In any case it's better to use variables in calculations, like
ROW(Table1[Medication])-ROW(Table1[[#Headers],[Key]])
instead of
ROW(Table1[Medication])-3