Vlookup with three criterias

[alfredo197135]

Hi guys,

Can you tell me how to use Vlookup with three criterias to find?

 

[Aladin Akyurek]

Syntax for MATCH function is match(lookup_value,array, type of match). Now in above formula how array is forming in match function?

MATCH(B2,IF(Sheet2!E2:E110511=A2,Sheet2!F2:F110511),0))... Please help me understand this part. Thanks!

I know how nested if works.

The IF(Sheet2!E2:E110511=A2,Sheet2!F2:F110511) creates a reference something like:

E2=A2 --> F2
E3=A2 -->FALSE (because E2 is not equal to A2)

Thus, we get an array F values and FALSEs, say...

{"JAD";FALSE;"KAD";"NAD";FALSE;FALSE;...}

The surrounding MATCH match the value of B2 against the forgoing array reference. If B2 would be equal to KAD, we would get a match at the 3rd position.

Hope this helps.