Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My VLookup argument isn't working. I'm trying to have it lookup the customer
id from my original worksheet in another worksheet, and have it return the (Co name) value from that second worksheet. When I don't ask it to do an exact lookup, it returns the correct value, but then when I drag the formula it just copies it. When I give it a FALSE range lookup for an exact match, then it won't return the value at all! I'm using the same vlookup formula that I always use. Here it is: =VLOOKUP(A2,'COMPANIES.csv'!$A$2:$O$15899,1,FALSE) What could be the problem? Can anyone help? -- Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |