I am using VLOOKUP for the first time and I don't have the formula written
correctly as it is returing REF#.
I have 2 worksheets and I want Excel to look at text in the 1st wksht and
find that same text in the second worksheet and then return the value
associatd with the text in the 2nd wkshty. Here is my fomula:
=VLOOKUP(B4,'Daily Activity'!A2:E101,5,FALSE)
B4 is the cell in the 1st wksht with the text I want to be found in the 2nd
wksht (Daily Activity). "5" is the column in the 2nd wksht that has values
that I want returned in the first wksht. Can anyone help me?
Thanks
--
Allan

The lookup data ('Daily Activity'!A2:E101 in your case) must be in the left
most column, so if you are looking up say "Cat" from the first sheet, the
formula is looking for Cat in column A and then returning the value in column
E on the same row. If this is how you have it set up then we will need more
data. If not, make sure the data that contains "Cat" on the second worksheet
is in the leftmost column.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Flipper" wrote:

I am using VLOOKUP for the first time and I don't have the formula written
correctly as it is returing REF#.
I have 2 worksheets and I want Excel to look at text in the 1st wksht and
find that same text in the second worksheet and then return the value
associatd with the text in the 2nd wkshty. Here is my fomula:
=VLOOKUP(B4,'Daily Activity'!A2:E101,5,FALSE)
B4 is the cell in the 1st wksht with the text I want to be found in the 2nd
wksht (Daily Activity). "5" is the column in the 2nd wksht that has values
that I want returned in the first wksht. Can anyone help me?
Thanks
--
Allan