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
Mutator function c++ - Guide
Network card function - Guide
Hard drive function - Guide
Mpc hc multiple instances - Guide
Find function on mac - 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

How to create two WhatsApp accounts on a Windows PC?

Cannot download multiple files at once in WhatsApp Web

"Sorry, this feature isn't available ... " how to fix this?

Can’t Log into Instagram from Multiple Devices

Dell laptop FN key is not working

Similar discussions

Subscribe To Our Newsletter!