Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Vlookup Formula

Comment:

Hi, i have column a with say for example 1444 Okuma, i than use the Left function to grab the first 4 characters and put it into column b than i use vlookup to get the data, now i know u cant use vlookup with formulas and column a will come from another source which is populated into excel and i have no control over this, is there any othe way of getting around this. Thanks Sal

Name: DerbyDad03
Date: May 12, 2008 at 09:07:54 Pacific

Reply:

What do you mean when you say "u cant use vlookup with formulas"? You can certainly use VLOOKUP to find the values that are returned by the LEFT function, either indirectly: =VLOOKUP("1444",B1:C20,2,0) where 1444 is the result of the LEFT function in Column B. or directly: =VLOOKUP(LEFT(A11,4),B1:C20,2,0) Please explain in a little more detail what you are trying to do.

0

Creating symmetric matrix...

Outlook removing signatur...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

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...

Summary: I am about to create a table to use in a vlookup formula. The table will consist of 300 different numbers in the left column. The right column will only have 6 different numbers. For example: Numbers ...

Summary: The gist of it is that you need another response in your formula after "empty" for the condition where it is not empty. You can enter the vlookup formula as ps-acc and Bryan did or you can enter text ...