I have a sheet that I need to get information from another sheet.
In K20 of CMT sheet, I want to look up the value in YTD sheet. The value will be from the Grand Total line(YTD sheet) and April(column). I need to search for Grand Total because the data may change next month, moving rows up or down.
Bookmarks