I know this might be long shot and that the chances of me finding someone like myself is limited but I'll take my chances. So I found this sub by typing khoja, but I wasn't looking for the Aga Khani Jamat, rather 'choti jammat' as we call ourselves. Are there any ex isna asheri khojas on here or if any of you know anyone? Still i have mad respect for you guys though seeing as my ancestors were aga khanis but ended up leaving the jammat for a more extremist and shittier belief lol.
With all the news happening, I thought i'd share some positive news. ISNA Mosque ran a food drive serving more than 700 families. If you or anyone needs help, I believe they run this program once a month regardless of faith and you can contact them as to how to access these services. Hope that helps and continue to stay safe everyone!
This isn't a problem per se, just an annoyance that I presume there must be a shortcut around...
I quite often have to reconcile a list of part numbers against another list, and want the formula to return a 0 (or run another calculation) if the part number doesn't appear on the second list.
For simplicity I'll pretend I'm checking for the existence of part number itself in column A against the adjacent column B, but in reality I might be checking associated qtys or costs against a list in another location. Example of what I currently do as follows:
=IF(ISNA(VLOOKUP(A1,B:B,FALSE)),0,VLOOKUP(A1,B:B,FALSE))
The duplication just seems inelegant, and like it should be unnecessary...
Thanks!
Any help is greatly appreciated!
I have an Attendees List on one worksheet and a Contact List on another worksheet in the same spreadsheet.
What I want: If the names on the Attendees List (column C; uses formula: =A2&" "&B2) match a name on the contact list (column C; uses the same formula: =A2&" "&B2), then it should return either 'Incomplete' or 'Complete' in the Contact column (Col. D on the Attendees List), depending on whether or not both the phone number and email address appear ('incomplete' if one is missing; 'complete' if both appear). 'No contact details' should appear if the name on the Attendees List does not appear on the Contact List.
This is the formula I wrote (as it appears on the Attendees List in cell D109): =IF(A110="","",IF(ISNA(MATCH(C110,Contacts!C:C,0)),"No contact details",IF(OR(ISBLANK(Contacts!D3),ISBLANK(Contacts!E3)),"Incomplete","Complete")))
Problem: this formula only works if the names on the Attendees List appear in exactly the same order as the names on the Contact List. Ideally, the formula should work regardless of the order of names on the Contact List. I suspect the issue is with the last IF statement, but I'm not sure how to write it correctly.
Help is much appreciated!
https://www.reuters.com/article/us-mideast-iran-tanker/explosion-sets-iran-owned-oil-tanker-on-fire-near-saudi-port-city-isna-idUSKBN1WQ0G0
https://youtu.be/qdWS2odn2w0
For real, I think that
Under all the hate for Arvo,
Can we all just accept that
Kenny wasn't justified in
.
Attacking him?
Really though, I'm
Very disappointed with the immaturity
Of this subreddit.
I need help in implementing the ISNA formula in VBA code. I am writing VBA to insert the following formula:
=VLOOKUP(F2, sheet2!$e:$by, 4, 0)
This formula in vba works if written as:
"=VLOOKUP(F2, sheet2!$e:$by, 4, 0)"
However, I am trying to do add IF(ISNA) to the formula to end with this result in the cell:
=IF(ISNA(VLOOKUP(F2, sheet2!$e:$by, 4, 0)), "", VLOOKUP(F2, sheet2!$e:$by, 4, 0))
I assume that the proper VBA code for this would be:
"=IF(ISNA(VLOOKUP(F2, sheet2!$e:$by, 4, 0)), """", VLOOKUP(F2, sheet2!$e:$by, 4, 0))"
However, this did not work. I know it is the "IF(ISNA)" throwing it off as the code works with the VLOOKUP by itself. Can anyone please assist?
Thank you in advance.
