Search results for query: *

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...

Hi Combo, Thank you Can I ask for some hand holding please, I lot of what you have done is new to me and I have only just upgraded from Office 2010 to 2021 so there is a lot of new stuff that I am still learning about. Re: Full Profile sheet You Said: I added one row and one column table Can...

Hi combo, Sorry Just getting my head round this On the Full Profile sheet If I clink in cell E2 the "Table Design" option pops up on the ribbon at the top Then when I click on the "Table Design" option I can see the new table name tMasterSel I don't have this option on my Full Workbook yet, so...

Hi combo, How do I change the "Full Profile" to show Table Design and Query tabs I tried Insert - Table - Table but it keeps creating Headers which I can't delete Thanks

Hi combo, Thank you There is a lot to take in with all these changes (some are new to me) So I will make the changes to my Excel work book one by one, then If/when I will have any questions I will get back to you I appreciate all your help

Hi Skip, Sorted out the Index/Match date problem with Blank Cells, works for all Pre and post 1900 Dates so this =INDEX(tMaster[Name],MATCH(E2, tMaster[Master ID],0)) Becomes this =IF(INDEX(tMaster[Name],MATCH(E2, tMaster[Master ID],0))="","",INDEX(tMaster[Name],MATCH(E2, tMaster[Master...