Yes - and you need to use the ROW function to do it. That way when your data moves, the formula will flag it with its new ROW location. VLOOKUP has four arguments: Lookup Value: The value you are using as a search term. Table array: the table through which to search. Search will occur in the first column, and only the first column until a match is found. Once a match is found, then the function will count over the specified number of columns and return that value. Column index number: the number of columns you want to count over from the left most column to pull over the matching value. NOTE: the left most column is counted as 1 Range lookup: what kind of match is allowable. TRUE or blank will allow Excel to use pattern matching and give you the nearest close match. If only exact matches are allowable (recommended in this case), use the argument FALSE. Here's how the function may look: =VLOOKUP(A1,$C$1:$F$500,4,FALSE)
Find latest posts