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

Some videos you may like

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
  •