Recent content by cneill

Hi Combo, Fixed it, thank you you so much for all your time, patience and understanding found the error I had =""),TRUE) should be ="",TRUE)) so the TRUE part was outside the second argument so had to include it as part of the second argument.

Hi Skip, This is the Function, which is partly working as described in previous posts =IF(OR(ISNA(MATCH($E$2, tWikiTree[Master ID],0)),INDEX(tWikiTree[WikiTree Link],MATCH($E$2, tWikiTree[Master ID],0))=""),"No Current Link to WikiTree", HYPERLINK(INDEX(tWikiTree[WikiTree Link],MATCH($E$2...

Hi Combo, Thanks I had tried that option, it just gives me a message of "You've Entered two few arguments for this function" when I press okay it highlights "" When I check through the Function for the OR(Logical1, Logical2,Logical3 it is now telling me the new IFERROR part we have just added...

Hi Combo, Thank you for your feed back, I am really trying to understand you and use your advice I think this is what the function should look like, if not please explain where I am going wrong. =IF(OR(ISNA(MATCH($E$2, tWikiTree[Master ID],0)),INDEX(tWikiTree[WikiTree Link],MATCH($E$2...

Thanks Skip I have now finally sorted it using a Nested If

Hi Combo Adjusted the function to this =IF(OR(ISNA(INDEX(tWikiTree[WikiTree Link],MATCH($E$2, tWikiTree[Master ID],0))="")),"No Current Link to WikiTree", HYPERLINK(INDEX(tWikiTree[WikiTree Link],MATCH($E$2, tWikiTree[Master ID],0)))) But for some reason it is still not quite right Let me give...

Hi Andrzejek, Yes your right, I tried that but it just returns (blank) If I manually add "No Current Link to WikiTree" to a (blank) cell on the tWikiTree, then it will return "No Current Link to WikiTree" Any Thoughts?

Hi Combo, Fixed So we now have =IF(OR(ISNA(MATCH($E$2, tWikiTree[Master ID],0)), ""),"No Current Link to WikiTree", HYPERLINK(INDEX(tWikiTree[WikiTree Link],MATCH($E$2, tWikiTree[Master ID],0)))) This works fine but now point 2 returns "blank" instead of #N/A which is great Is there a way to...

Hi Combo, Thank you I have tried to rework the function as you describe but I must have something wrong New Function =IF(OR(ISNA(MATCH($E$2, tWikiTree[Master ID],0)),tWikiTree[WikiTree Link] = ""),"No Current Link to WikiTree", HYPERLINK(INDEX(tWikiTree[WikiTree Link],MATCH($E$2...

Some help would be greatly appreciated I am struggling to find a way to combine these two functions The aim if to returns one of the following three results The selected "Master ID" is in Cell $E$2 The Function is in Cell F2 1.) The "Master ID" that is selected from cell $E$2 finds a matching...

Hi Skip & Combo, Just a quick thank you for all your help Combo I got your Power Query to work, which is great, but in the end I settled for a more simplistic approach and used the =Filter function Which is easier for me to implement. One other question to you both If I use the "Master ID" on...

Hi Combo, Forgot to say When I add =INDIRECT("tMaster[Master ID]") to the data validation for E2 on the profile page it gives me a message to say "The Source currently evaluates to an error, do you want to continue Yes or No What have a missed

Hi Combo, I think I have now made all your changes When I go into the Power Query It is telling me Expression.Error: The column 'Master ID' of the table wasn't found. Details: Master ID In the code it says = Table.TransformColumnTypes(Source,{{"Master ID", Int64.Type}}) Also my workbook is...

Hi Combo, Sorted Thank you Re Changes 1.) Resize 'tArtwork' table to cover full data - How do I do this? 2.) Master-ID' field in 'tArtwork' table DV formula changed to =INDIRECT("tMaster[Master ID]") - I can't find this change you made, where is it? Thanks

Hi Combo, In my Master Workbook I made a copy of the Full profile Sheet and renamed the current one as Full profile Old (full back position if I do something wrong) Clicked on E2 Full profile Sheet and Inserted the table, I confirmed the table was located at $E$2, I confirm my table has a...