Forum Discussion
VLOOKUP to the left
Hi, I have windows 10 and Excel 2016 I came across this formula on for VLOOKUP to the left but didn’t understand it VLOOKUP(F7,IF({1,0},D:D,B:B),2,0) In both these cases the...
this is an array formula inside logical_test IF,
{1,0} or {1\0} represent {TRUE,FALSE} or {TRUE\FALSE}since logical_test {1,0} is an array, formula IF will excecute 1 (or TRUE) and 0 (or FALSE), it's mean D:D and E:E will show, and it will create table_array D:E for VLOOKUP