Vlookup formula in excel: Hi there is it possible

Hi there is it possible to have a Subtotal formula in a vlookup formula . I am running into a problem with the vlookup as there are number enteries that I need adding. Example below Stephen 26 John 32 John 34 Stephen23 Peter 24 Stephen6 So I am vlookining up for the name and then need to add... May 2, 2025 Ramballah Z Need to update formula VLOOKUP zone709 Jun 6, 2025 Excel Questions Replies 2 Views 162 Jun 8, 2025 Hoping there's a MrExceler out there who can help me. I am trying to figure out how to lookup information in a filtered table, returning only visible values. For example, let's say that the data I want to use for the lookup is in cell A1, the lookup data is in cells A3:A10, and the data I want... I created a VLOOKUP table on another sheet, convert, in the workbook. I created the following formula , = VLOOKUP (C9,convert!A2:B452,2,) But when I try to replicate down to the next cell in the column, the C9 increases to C10, which is expected, but the range of the VLOOKUP also increases to...