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 IF() with VLOOKUP()

The formula works by testing the provided conditions, if the statement is true, the first argument (first vlookup) is returned. Otherwise second argument (i.e. second vlookup) is returned. 

Used Functions

Category: Logical

Specifies a logical test to perform


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


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

Lets chat on this