I want to do a vlookup (referring to a range on another sheet) in a cell, if the value in the preceding cell is "y".
I have tried =if(B2="y",=vlookup(B1,Clients,3,false),""), where
B2 is the cell on sheet 2 that I enter y or n
BI is the cell on Sheet 2 containing the 'trigger' value
Clients is the named range in Sheet 1
and 3 is the column on Sheet 1 to look up. But this doesn't work.