If Function with Multiple statements including Vlook up
Closed
Hello,
Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. if not then read the 2nd if formula.
Currently i have :
=IF(or(vlookup($H:H,'Freedom Report'!B:BF,24,False)=AV$1,"Registered", IF(U13="Yes","Pending",IF(U13="No","x",IF(U13="","","")))))
but its not working. Help please!!
Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. if not then read the 2nd if formula.
Currently i have :
=IF(or(vlookup($H:H,'Freedom Report'!B:BF,24,False)=AV$1,"Registered", IF(U13="Yes","Pending",IF(U13="No","x",IF(U13="","","")))))
but its not working. Help please!!
Related:
- If Function with Multiple statements including Vlook up
- Accessor function c++ - Guide
- How to lasso multiple objects in photoshop - Guide
- Find function on mac - Guide
- Spreadsheet function - Guide
- Allow multiple downloads chrome - Guide
Oct 21, 2016 at 07:00 PM
If you wish to find H:H then use "H:H"!
Oct 22, 2016 at 10:58 AM
Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 1 arguments."
yes the information in column H is the only constant ID that matches the data that im searching in.
I'm not understanding "H:H"!
Oct 24, 2016 at 05:02 PM