What is incorrect about these formulas that I can fix? It keeps popping up \"#VA

Question

What is incorrect about these formulas that I can fix?  It keeps popping up "#VALUE!" as an error and even going through EXCEL Help tutorials, I cannot figure out where it is causing the error.

=IF(VLOOKUP(MAX('Cash Drawer'!$A:$A),S_Cash_Count,10, FALSE)<40,"Email "&Supervisor&" About Quarters!","")

="Last Counting:  "&VLOOKUP(MAX('Cash Drawer'!$A:$A),S_Cash_Count,2, FALSE)

=IF(VLOOKUP("Last",S_Cash_Drawer,18, FALSE)=0,VLOOKUP(MAX('Cash Drawer'!$A:$A),S_Cash_Drawer,18, FALSE),VLOOKUP("Last",S_Cash_Drawer,18, FALSE))

Explanation / Answer

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Lookup_value    The value to search in the first column of the table array. Lookup_value can be a value or a reference. If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.

Table_array    Two or more columns of data. Use a reference to a range or a range name. The values in the first column of table_array are the values searched by lookup_value. These values can be text, numbers, or logical values. Uppercase and lowercase text are equivalent.

Col_index_num    The column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is:

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.