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...
OFFSET(D7,ROW(D7:D17)-ROW(D6),COLUMN(H7)-COLUMN(E7:G7)) evaluates to a single value, not to an array.
When i pressed F9 on this part in the table_array part and pressed enter it evaluated correctly
Yes, but not in the final formula. Perhaps someone else can explain that.