LinkBack URL
About LinkBacks
In the attached file I am recieving a Index/Match - #value error, i believe it is because the data type between the files are different but I have changed them to all general and do not get any other results. Help please!
In the attached file I am recieving a Index/Match - #value error, i believe it is because the data type between the files are different but I have changed them to all general and do not get any other results. Help please!
Those are array formulas.
You need to activate cell D8, by hitting F2, then hold the CTRL+SHIFT keys down and hit ENTER. You will see { } brackets appear around it.
Then copy down.
Repeat for other column.
If you want to avoid the Array formula, add an INDEX around the MATCH...
e.g. in D8, =INDEX(PhysMaster!$A$2:$A$36,INDEX(MATCH(B8&A8,PhysMaster!$B$2:$B$36&PhysMaster!$A$2:$A$36,0),0)) copied down
and in E8: =INDEX(PhysMaster!$B$2:$B$36,INDEX(MATCH(A8&B8,PhysMaster!$A$2:$A$36&PhysMaster!$B$2:$B$36,0),0)) copied
down.
You can also rearrange some relative/absolute referencing and use one formula in D8:
=INDEX(PhysMaster!A$2:A$36,INDEX(MATCH($B8&$A8,PhysMaster!$B$2:$B$36&PhysMaster!$A$2:$A$36,0),0))
copied to next column and down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks so much.... is there anyway to build a if statement that says if column a and column d do not match enter false - if they do enter true
Is this a separate question because there is no reference to column D in your initial question?
I am sorry Column D is new data that is generated from the above match formula
Can you look on the actual-class file I am getting NA on each of these do I have something incorrect in the formula?
So comparing same row references?
eg
=IF(ISNA(D8),FALSE,A8=D8)
copied down?
thanks for if statement
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks