Resolved: Exercise Solution - Column array seems wrong but still returns correct number?

in Advanced Microsoft Excel / Advanced Excel Functions Rows; Columns; Vlookup & Columns

Why do I get the correct Aug number for Store E when the column array is in Store B? Shouldn't I get the Store B number in that case?

1 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

04 Feb 2023

Hello,

The COLUMNS function works as a counter. It simply counts the number of columns you have from B to J and tells Excel to provide the respective value from the source table (table_array). Best,

Ned

Helpful answer

Resolved: Exercise Solution - Column array seems wrong but still returns correct number?

Submit an answer

related questions