Please enable JavaScript to view the comments powered by Disqus.


IF(...C18="School 1",VLOOKUP(...C19,A5:C16,3,0),VLOOKUP(...C19,E5:G16,3,0))

How to use different Vlookup() with TRUE and FALSE condition

The formula works based on the TRUE and FALSE conditions that are returned by IF() function. When TRUE a specific case of VLOOKUP() is returned and else wise the second option of VLOOUP() is returned.


Used Functions

Category: Logical

Specifies a logical test to perform

Syntax

IF(Something is True, then do something, otherwise do something else)

Category: Lookup and reference

Looks in the first column of an array and moves across the row to return the value of a cell

Syntax

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Lets chat on this