I have a IF Index Match formula, it sorta works.. for some reason it wont pull the information 100% correctly...
Formula is: =IF(NrwdRwdAcct[BRPRec]="Rec",INDEX(NrwdRwdAcct[BRP],MATCH(NrwdRwdAcct[Acct '#],[@[Acct '#]],0)),INDEX(NrwdRwdAcct[BOS RWD],MATCH([@[Acct '#]],NrwdRwdAcct[Acct '#],0)))
In the tables and columns there is information.. the beginning of the formula it looks to see if That cell has "Rec" in it if it does it should run the Index match and Return a Yes not a Dollar amount... then I have another cell that it should be returning the dollar amount and it is coming up NA or if i make changes it is coming up with a Word that is in that column next to the dollar amount...
I have tried a number of variations, even tried a entirely different formula... but no go..
I have that formula in a different sheet well not same wording for headers and table , but its pulling from two tables on same sheet just fine... no errors...
Please tell me where i goofed...
Formula is: =IF(NrwdRwdAcct[BRPRec]="Rec",INDEX(NrwdRwdAcct[BRP],MATCH(NrwdRwdAcct[Acct '#],[@[Acct '#]],0)),INDEX(NrwdRwdAcct[BOS RWD],MATCH([@[Acct '#]],NrwdRwdAcct[Acct '#],0)))
In the tables and columns there is information.. the beginning of the formula it looks to see if That cell has "Rec" in it if it does it should run the Index match and Return a Yes not a Dollar amount... then I have another cell that it should be returning the dollar amount and it is coming up NA or if i make changes it is coming up with a Word that is in that column next to the dollar amount...
I have tried a number of variations, even tried a entirely different formula... but no go..
I have that formula in a different sheet well not same wording for headers and table , but its pulling from two tables on same sheet just fine... no errors...
Please tell me where i goofed...
