Kamalakkannan Raju
New Member
Hello all,
In the attached excel sheet, column "L" of Summary sheet, based on time i am trying to lookup the position of the ISIN in Col. E of the Summary sheet in the data given in Dump sheet.
When doing so, amongst the 9 line items, the formula is working for 6 of them but for the other 3 rows, its returning #N/A error. But the surprising part is, when i go to the formula bar and hit F9 separately for those giving errors, for Filter function and match function, it shows that the position of the ISIN( In case of "IN2020220124", its 1). Then how come the its throwing error when i drag and drop the formula across the entire column.
PS: The data in the Dump sheet is sorted time wise and ISIN wise. Also, if you see the filter and match combo is working fine in case of col. O to col. R in the summary sheet.
Please someone guide me as to why #N/A error is coming in only in a few places.
Thanks again
In the attached excel sheet, column "L" of Summary sheet, based on time i am trying to lookup the position of the ISIN in Col. E of the Summary sheet in the data given in Dump sheet.
When doing so, amongst the 9 line items, the formula is working for 6 of them but for the other 3 rows, its returning #N/A error. But the surprising part is, when i go to the formula bar and hit F9 separately for those giving errors, for Filter function and match function, it shows that the position of the ISIN( In case of "IN2020220124", its 1). Then how come the its throwing error when i drag and drop the formula across the entire column.
PS: The data in the Dump sheet is sorted time wise and ISIN wise. Also, if you see the filter and match combo is working fine in case of col. O to col. R in the summary sheet.
Please someone guide me as to why #N/A error is coming in only in a few places.
Thanks again