Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VLookup assistance
Name: HB Hays Date: June 10, 2005 at 08:27:14 Pacific OS: XP CPU/Ram: pentium and 1024
Comment:
VLookup assistance..... Columm B takes the left 4 numbers from a longer number in column A. I am trying to use VLookup to look up the resulting 4 numbers in a different colukmn but it won't. If I simply type the number in, it works fine but it will not work by looking up the results from the LEFT 4 function. What could cause this?
Name: Bryco Date: June 10, 2005 at 11:29:04 Pacific
Reply:
Let's say that your number is 123456 and is in A1 then use =LEFT(A1,4) Meaning in A1 extract the first four characters from the left. and the result will be 1234 in the cell where you placed the formula.
HTH Bryan
0
Response Number 2
Name: HB Hays Date: June 11, 2005 at 05:46:24 Pacific
Reply:
Bryan, That is what I did and VLookup will not lookup the resulting 1234 on a different worksheet. ???? I'm trying to figure out why it won't recognize the 1234 that is the result of the =left(a1,4) function but it will recognize it if I simply type in the numbers 1234. Any ideas?
0
Response Number 3
Name: MarkUS Date: June 11, 2005 at 11:00:42 Pacific
Reply:
Left(A1,4) is actually a text function and produces a text value '1234'. If you are using it in a lookup function and the lookup column contains numeric values, then the compare or lookup fails.
Summary: Hope someone can assist with a problem I have never previously encountered. I am trying to add a column to a spreadsheet with the formula '=0&<Cell details', which returns the contents of the chose...
Summary: Are you running through an Exchange server? If so, and you set up the Out of Office Assistant, you can edit the rule to perform whatever action you wish. Life is more painless for those who are brain...
Summary: HI, I'm trying to write a VLOOKUP formula =VLOOKUP(B15,D2:Q12,2,FALSE) where B15 is a date (eg =DATE(2006,2,17)) and it is meant to look for that date in the first row of the array. I'm constantly get...
0 
Can't open Word Document
