If statement with a Vlookup

[waxb18]

i want to perform this vlookup but i only want it to perform it IF the data in column AY states "Unknown"

VLOOKUP(A51,'RAW OPEN DATA'!$B$20:$S$1048576,16,FALSE)

Any ideas???

 

[ZPhantom]

Try:

=IF(AY51 = "Unknown", VLOOKUP(A51,'RAW OPEN DATA'!$B$20:$S$1048576,16,FALSE), "")

change cell references as needed

 

[waxb18]

would this only use cell AY51 as the reference for unknown?

Should it not be AY:AY = "unknown" ??

 

[ZPhantom]

The way i've written it will only check AY51 yes, (TBH i used it as you have a ref to A51)

stick AY:AY in and see what happens.

 

[waxb18]

Ok brilliant it works perfectly thanks

One quick one though, say i wanted to multiple if statements
say column B against a number say 53 would i use the same method?

 

[ZPhantom]

You could do, nested statments get complicated quickly though so i try and avoid multiple if statements, I think AND, OR etc.. look prittier
both take 2 or more arguments seperated by commas,
AND returns TRUE if all arguments inside are right
OR returns TRUE if ANY arguments are right

try

 =IF(AND(AY51 = "Unknown", B51 = 53), VLOOKUP(A51,'RAW OPEN DATA'!$B$20:$S$1048576,16,FALSE), "")

have a try and put AY:AY, B:B where you think they should go

 

[waxb18]

unfortunately it hasnt worked,

What ive decieded to do is create a new column and use a few &'s in my daya so i have things like "unknown50" then done a vlookup against this to give me my values

Thanks for the help