wildcard if function

I can't seem to figure this one out. I use this formula to search in other tables for multiple types of values. It always works like a charm, but, this year I've added two new categories "P-8" and "T-8" (the number 8 can range from 1-8, hence why i'm trying to use the asterisk) and it's not...

Hi All, May you help me with below? Name in Column "H" will be the lookup value vs "A" and "D". Other condition is in the table:

Hi all, First I want to apologize if my question lacks some formula knowledge, I'm new to this level of Excel and trying to figure this out. Second, I want to thank all for tolerating my ignorance. Here is my challange: I'm designing a stopgap solution for querying a large Excel spreadsheet...

Right off the bat, if this should be broken out into 2 separate threads, I apologize and will adjust accordingly (if possible). I just see the two issues somewhat related and so thought that perhaps I could get them both done in one swing. Part 1: The two workbooks I am using are: WorkbookA &...

I have been attempting to use wildcards and it seems to work with in sumif functions but not in if functions. <tbody> 45 10efs22 25 22wqa11 310 22azx11 64 22qaz11 264 11efs34 94 66efs99 294 11efs55 612 11ert66 981 99ijk00 62 77yhn66 64 22ert66 97 66yhn44 65 44rfv55 44...