Previous Topic Next Topic

If Function with Multiple statements including Vlook up

Closed
jenn - Oct 21, 2016 at 04:58 PM
 Blocked Profile - Oct 24, 2016 at 05:02 PM
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!!

Related:

1 response

Answer 1 / 1
Blocked Profile
Oct 21, 2016 at 06:53 PM
What error do you get, or do you get a value?
0
Blocked Profile
Oct 21, 2016 at 07:00 PM
You are trying to match a RANGE: $H:H

If you wish to find H:H then use "H:H"!
0
Jenn
Oct 22, 2016 at 10:58 AM
The error i get is #N/A with the comment "Error
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"!
0
Blocked Profile
Oct 24, 2016 at 05:02 PM
Quote H:H End Quote = "H:H"
0

Similar discussions

Can’t Log into Instagram from Multiple Devices
Isabella -
Abhishek0025 -

5 responses