Hello all,
I am running an INDEX MATCH function (as I do frequently); honestly, this error has never happened to me - I have about 800 lines of data from the source tab in which I am trying to link over into a new tab (same workbook). For the vast majority of line items everything is fine - the data is coming over fine. But for certain fields in which I am linking over, I am getting a "null" or blank cell in return on the new tab (when there is definitely data in the source tab cell).
Seems very odd. Each line item has 12 fields. And again, for certain line items are returning all 12 values. Others are bringing back 10 or 11 values, with 1 or 2 blanks.
=IF(INDEX(FAL1_FV,MATCH($C67,FAL1_FV_AC_row1,0),MATCH(E$10,FAL1_FV_AC_clmn1,0))="","",INDEX(FAL1_FV,MATCH($C67,FAL1_FV_AC_row1,0),MATCH(E$10,FAL1_FV_AC_clmn1,0)))
C67 - is the link to the 2 tabs; FAL1....are the naming conventions to the source tab; E10 is the value on the top of each column in the source that the INDEX MATCH is looking up.
Let me know any thoughts. Thanks!
I am running an INDEX MATCH function (as I do frequently); honestly, this error has never happened to me - I have about 800 lines of data from the source tab in which I am trying to link over into a new tab (same workbook). For the vast majority of line items everything is fine - the data is coming over fine. But for certain fields in which I am linking over, I am getting a "null" or blank cell in return on the new tab (when there is definitely data in the source tab cell).
Seems very odd. Each line item has 12 fields. And again, for certain line items are returning all 12 values. Others are bringing back 10 or 11 values, with 1 or 2 blanks.
=IF(INDEX(FAL1_FV,MATCH($C67,FAL1_FV_AC_row1,0),MATCH(E$10,FAL1_FV_AC_clmn1,0))="","",INDEX(FAL1_FV,MATCH($C67,FAL1_FV_AC_row1,0),MATCH(E$10,FAL1_FV_AC_clmn1,0)))
C67 - is the link to the 2 tabs; FAL1....are the naming conventions to the source tab; E10 is the value on the top of each column in the source that the INDEX MATCH is looking up.
Let me know any thoughts. Thanks!