Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cneill

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

    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?
  8. cneill

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

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

    Combining If and Iferror and Index/Match with Hyperlink

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

    Hi, I am trying to get my head rou

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

Part and Inventory Search

Back
Top