-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ifisna
-
E
vlookup with match to return a result with multiple rows with lookup value
So I have a doozy of a question. I have 2 tables. Table 1: contains a list "Sites=siteID" on each row. Columns contain "Device Name" 1-30 Table 2: contains "SiteID", "Device Name" SiteID is over multiple rows See examples Table 1: Site ID Device Name 001 Device Name 002 Device Name 003...- excelnoob_67
- Thread
- ifand ifisna match vlookup
- Replies: 15
- Forum: Excel Questions
-
D
Issue with Nested IF(ISNA(INDEX(MATCH Equation
I have scoured the Internet and I fell like this equation is correct, but there is something not right. I have three Access Database Queries that cannot be merged and I am using: IF(ISNA(INDEX(InstallQuery!F:F,MATCH('Install Report Week...- djobiii
- Thread
- ifisna index match nested week
- Replies: 3
- Forum: Excel Questions
-
L
If(ISNA(VLOOKUP Help... VBA
Any advice as to why the below formula isn't working? My goal is supposed to return a "1" if the vlookup identifier is not found (ISNA) & add a 1 to the cell IF the identifier is found (IF, +1). Any advice? I've pasted what I am working on below =IF(ISNA(VLOOKUP(C[-2],'[PBDunkAcc.xlsx]Merrill...- Legacy 313594
- Thread
- ifisna isna vba vlookup
- Replies: 5
- Forum: Excel Questions
