Multiple validation (If statement)

[JayReina]

This is my best effort but it dosen't work

=IF(MATCH($B$5,vMax_Capacity.csv!$A:$A,0),AND(MATCH($A$10,vMax_Capacity.csv!$B:$B,0),"true")
This will get me a "TRUE" output


Here is when i go wrong.... When i get a validation match I want to have the value from that row and colum F inputed in the cell
=IF(MATCH($B$5,vMax_Capacity.csv!$A:$A,0),AND(MATCH($A$10,vMax_Capacity.csv!$B:$B,0),INDEX(vMax_Capacity.csv!$F:$F,$B$9,$A$10)))


Example:


B5= A
A10= B

Colum A Colum B Colum F
Row9 A B 123 <----------My Output

~J

[azumi]

Can You upload the files, so i could figure it out better

[JayReina]

So here is an example

I need to get the Pool capacity if Site Name and pool's name are equal to the B5 and B11 to B15


SO if Site = "Data Center" and Pool = "Car" I should get on the "97" on the cell


File is attached

[azumi]

=VLOOKUP($B$5;IF(DataSheet!B2:B12=A11;DataSheet!A2:C12;"");3;FALSE)

tRY THIS

[azumi]

=IFERROR(VLOOKUP($B$5;IF(DataSheet!B2:B12=A11;DataSheet!A2:C12;"");3;FALSE);"Not Avalaible")

or u can add error trapping here

Don't forget Replace ";" with Comma of course ","

Coz my computer use different setting

[azumi]

Here the files

[JayReina]

So in my actual sheet ...(I have multiple)...I enter the code it seems right but when i do the CSE comman it does not convert have you seen this before?

=IFERROR(VLOOKUP($B$5,IF(vMax_Capacity.csv!$B2:$B100=A11,vMax_Capacity.csv!$A$2:$G$150,""),6,FALSE),"Not Available")


Thanks in Advance

~J

[azumi]

I try to modification your table

Regards

[JayReina]

Thx...I don't know what it was but if I hit "F2" and the CSE it works ....weird but it works ...thanks

[azumi]

U Welcome