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!!

If Function with Multiple statements including Vlook up
How many if statements can you nest - Guide
Allow multiple downloads chrome - Guide
How to delete multiple files at once - Guide
Agp function - Guide
If then statements in excel - Guide

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?

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"!

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"!

Blocked Profile
Oct 24, 2016 at 05:02 PM

Quote H:H End Quote = "H:H"

Similar discussions

Excel - IF function with multiple words

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!