hard20 pts · first answer countsexcellookups

Wrong values after inserting a column

A sheet uses =VLOOKUP(A2,Data!A:F,4,FALSE) to return Price. Someone inserts a new column in the Data sheet between B and C. What happens?

A.It updates the 4 to 5 and still returns PriceB.It returns #REF! until the file is savedC.It returns #N/A for every rowD.It now returns the old 3rd column, not Price

Discussion 0

Join free to post in the discussion.

Wrong values after inserting a column

Discussion 0

Related questions