VLOOKUP function - Page 2
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: VLOOKUP function

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ah, i see

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-12 02:35, KnAsTa wrote:
    Thanx Aladin Akyurek,
    it worked.

    But how do you do it for two columns now?
    like searching two columns in an external worksheet for 1 value.
    Sorry but I'm unsure of what your trying to achieve.

    by two columns do you mean search both columns for the same thing?
    or
    search the first column in a two column range and return the value/text in the next column?

    a coment has been made as to why you're using 1 column:
    the reason this was asked is that using =VLOOKUP(What_to_look_for,in_this_range,return_value_from_this_column)
    the way you seem to be using it, means that if I type 'Ian' in a cell and return the value from column 1 the return will be 'Ian' which is the same, so I don't see the need to look for a value in the first place?

    If however you want to now extented the formula to return what is in column 2 of the range, use:

    =VLOOKUP(A5,[week1.xls]Sheet1!$A$1:$B$10,2,0)

    doing this you have selected two columns $A$1:$B$10 and specified that you'd like the result to come from col 2.

    so if I type 'Ian' in for the lookup_criteria and in the table it has 40000 (the salary I wish I had), it would return 40000 as a result.

    Confused

    Hope this helps

    "Have a good time......all the time"
    Ian Mac

  3. #13
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yeah thanx, it was helpful, yet disturbing......

    How can we modify what VLOOKUP returns so that it returns a boolean, so i could say:
    IF it IS in column 1, do this, else... Because right now it is returning a string from my external spreadsheet, and it wont let me use it.....
    Confused....?

  4. #14
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    did anyone understand my previous post? I really need to get this to work, its for an assignment.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

DMCA.com