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() to get conditional vlookup

We use IF() to get the vlookup formula according to our requirement. If the given condition comes true, the first argument of the IF() function is return that corresponds to a specific range, otherwise the second argument is returned that lookup in the second range. 


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