Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |