|If you do not get it to work after this post, please tell me what cell(s) you are using for the VLOOKUP formula.|
The syntax of your latest attempt is wrong:
Let's break the VLOOKUP arguments down piece by piece.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
table_array: 'Pivot-DL$ (A1)'!$A$7:$E$11
col_index_num: You want 2, more on this later
The range_lookup argument should only be FALSE (0) or TRUE (1) A range_lookup argument of -2 is going to give you invalid results.
First, let's discuss your lookup_value... value...C16
If you are dragging this formula across columns, you have to lock the lookup_value also or it will increment from C16 to D16 to E16 as you drag it across.
If you always want to lookup C16, you have to use $C16 which will lock the Column but allow the Row to increment if you are also dragging it down.
Second, your table_array...
I can only assume that 'Pivot-DL$ (A1)'!$A$7:$E$11 is a valid table_array for your workbook. Since I can't see your workbook from where I'm sitting, I'll have to trust you that it is a valid table_array.
Third, your col_index_num...
Did you try any of the tests I suggested as a means to familiarize yourself with the COLUMN function?
I don't have any other way to explain it other than it simply returns the Column number of the Column it is used in.
If you put this in D16, it will return 4, because D is the 4th Column on a worksheet.
If you put this in D16, it will return 2, since 4 - 2 = 2
Therefore, if you put this in D16:
it will be equivalent to:
Finally, your range_lookup argument...
As I said earlier, this has to be 0 (FALSE) or 1 (TRUE) or omitted, which is the same as TRUE. Since I assume you are looking for an exact match, you want the range_lookup argument to be 0 (FALSE).
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.