VLOOKUP Question

[superdrno]

Hey,
Attached is what I am working on. I have 2 tabs an Original and a Summary. I am trying to have it so that when I update the date in the Original tab, the Summary tab automatically updates the date using a VLOOKUP. But I keep getting a #REF error and was wondering if I could get some help.

=VLOOKUP(A2,Original!$B$2:$B$18,3,FALSE)

[JOHN H. DAVIS]

Maybe:

=VLOOKUP(A2,Original!$B$2:$C$18,2,FALSE)

[sourabhg98]

This is because whole range has to be included in the array. In B:B there is no third column so it returns an error. So it should be B:D or B:E or anything after D, so that 3rd column i.e. D is a part of the array.

Please Login or Register  to view this content.

EDIT-
However, I just saw that in your case you are actually referring to Column C. So it should be-

Please Login or Register  to view this content.

Although Column C is 3rd but in array B:C it is the 2nd column.

[dominicb]

Good afternoon superdrno

Please Login or Register  to view this content.

The "$B$2..." part refers to an array - think of it as a table.
The ",2," part is the number of columns in your table Excel needs to count across - you've only got two columns in your table, so it can't be greater than 2.

HTH

DominicB

[superdrno]

Ohh thank you all so much. One follow on. what if in the original tab Column B is the task name and there are 3 columns in between and Column F is now the new column with dates? how would this change the formula?

[JOHN H. DAVIS]

Ohh thank you all so much. One follow on. what if in the original tab Column B is the task name and there are 3 columns in between and Column F is now the new column with dates? how would this change the formula?

Then


=VLOOKUP(A2,Original!$B$2:$F$18,5,FALSE)