+ Reply to Thread
Results 1 to 119 of 119

vlookup help

  1. #1
    Registered User
    Join Date
    06-27-2005
    Posts
    15

    vlookup help

    So i'm attempting this one more time because i haven't been able to get it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true. This formula i've gotten from the excel help file and doesn't work for me.

    Can someone please help??!

    Thanks in advance,
    Jeff

  2. #2
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  3. #3
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  4. #4
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  5. #5
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  6. #6
    Registered User
    Join Date
    06-27-2005
    Posts
    15
    Stumped!!

    I've tried everything you guys through at me and nothing works, I get the error!

    I hope I have explained everything correctly, but I will rephrase.
    in colb of sheet 1 I have urls that I need to update. I would like to search through sheet2 colb (contains the corresponding urls) and insert the hit count (located in col a of sheet 2) into a cell in sheet1.
    The hits are sorted into an ascending order. I can re-order the list if i need to.

    I have tried all of the suggestions that all of you have given me to no avail.

    Any suggestions?
    Jeff

  7. #7
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  8. #8
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  9. #9
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  10. #10
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  11. #11
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  12. #12
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  13. #13
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  14. #14
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  15. #15
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  16. #16
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  17. #17
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  18. #18
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  19. #19
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  20. #20
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  21. #21
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  22. #22
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  23. #23
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  24. #24
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  25. #25
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  26. #26
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  27. #27
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  28. #28
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  29. #29
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  30. #30
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  31. #31
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  32. #32
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  33. #33
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  34. #34
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  35. #35
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  36. #36
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  37. #37
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  38. #38
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  39. #39
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  40. #40
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  41. #41
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  42. #42
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  43. #43
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  44. #44
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  45. #45
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  46. #46
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  47. #47
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  48. #48
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  49. #49
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  50. #50
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  51. #51
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  52. #52
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  53. #53
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  54. #54
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  55. #55
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  56. #56
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  57. #57
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  58. #58
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  59. #59
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  60. #60
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  61. #61
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  62. #62
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  63. #63
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  64. #64
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  65. #65
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  66. #66
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  67. #67
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  68. #68
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  69. #69
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  70. #70
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  71. #71
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  72. #72
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  73. #73
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  74. #74
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  75. #75
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  76. #76
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  77. #77
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  78. #78
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  79. #79
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  80. #80
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  81. #81
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  82. #82
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  83. #83
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  84. #84
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  85. #85
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  86. #86
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  87. #87
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  88. #88
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  89. #89
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  90. #90
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  91. #91
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  92. #92
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  93. #93
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  94. #94
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  95. #95
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  96. #96
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  97. #97
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  98. #98
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  99. #99
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  100. #100
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  101. #101
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  102. #102
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  103. #103
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  104. #104
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  105. #105
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  106. #106
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  107. #107
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  108. #108
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  109. #109
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  110. #110
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  111. #111
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  112. #112
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  113. #113
    Alan
    Guest

    Re: vlookup help

    =vlookup(b2,'sheet2,a2:b940,1,false)

    Try

    =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)

    Post back if that doesnt work,
    Regards,
    Alan.
    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...
    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile:
    > http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >




  114. #114
    pdberger
    Guest

    RE: vlookup help

    JPriest --

    I think you need to change the '1' to a '2' in your vlookup statement. That
    number counts the columns over to the right, but '1' is the index column
    itself. The 'false' or 'true' has to do with whether you want an approximate
    match or an exact match in the index column, and may not be necessary.

    Also, I think the statement you wrote in this e-mail has syntax errors. You
    have a starting apostrophe but no ending one, and I think you have to put an
    '!' after the worksheet name. Try:

    =vlookup(b2,'sheet2'!a2:b940,2)

    Use the 'true' or 'false' if you really need to.

    hth
    "JPriest" wrote:

    >
    > So i'm attempting this one more time because i haven't been able to get
    > it to work for me yet.
    >
    > Here's the situation:
    >
    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1
    >
    > here's the formula i have tried and gotten an NA# error
    > =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    > This formula i've gotten from the excel help file and doesn't work for
    > me.
    >
    > Can someone please help??!
    >
    > Thanks in advance,
    > Jeff
    >
    >
    > --
    > JPriest
    > ------------------------------------------------------------------------
    > JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
    > View this thread: http://www.excelforum.com/showthread...hreadid=400874
    >
    >


  115. #115
    kk
    Guest

    Re: vlookup help

    Hi JPriest,

    > I want to find the value in sheet1b2 in sheet2 col b and return the
    > value in sheet2 col a to an empty cell in sheet 1


    From my understanding, Vlookup doesn't work this way.

    The values you want to find has to be located in a column to the left of the
    data that you want to return.

    So you have to rearrange your data to in order to get your formula works.

    Col A - The value you want to find
    Col B - The value you want to return.


    If due to certain reason you can't rearrange the data, try...

    =Offset(Sheet2!$A$1,Match(B2,Sheet2!$B$2:$B$940,0),0)

    Hope this help.

    kk


    "JPriest" <JPriest.1un4mi_1125511533.9619@excelforum-nospam.com> wrote in
    message news:JPriest.1un4mi_1125511533.9619@excelforum-nospam.com...

    So i'm attempting this one more time because i haven't been able to get
    it to work for me yet.

    Here's the situation:

    I want to find the value in sheet1b2 in sheet2 col b and return the
    value in sheet2 col a to an empty cell in sheet 1

    here's the formula i have tried and gotten an NA# error
    =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    This formula i've gotten from the excel help file and doesn't work for
    me.

    Can someone please help??!

    Thanks in advance,
    Jeff


    --
    JPriest
    ------------------------------------------------------------------------
    JPriest's Profile:
    http://www.excelforum.com/member.php...o&userid=24695
    View this thread: http://www.excelforum.com/showthread...hreadid=400874



  116. #116
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  117. #117
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


  118. #118
    Alan
    Guest

    Re: vlookup help

    Using '1' as the column to display in a VLOOKUP does work, pointless, but it
    works,
    Regards,
    Alan.
    "pdberger" <pdberger@discussions.microsoft.com> wrote in message
    news:26E7D94D-AFC2-430D-BF3C-D4770226BB22@microsoft.com...
    > JPriest --
    >
    > I think you need to change the '1' to a '2' in your vlookup statement.
    > That
    > number counts the columns over to the right, but '1' is the index column
    > itself. The 'false' or 'true' has to do with whether you want an
    > approximate
    > match or an exact match in the index column, and may not be necessary.
    >
    > Also, I think the statement you wrote in this e-mail has syntax errors.
    > You
    > have a starting apostrophe but no ending one, and I think you have to put
    > an
    > '!' after the worksheet name. Try:
    >
    > =vlookup(b2,'sheet2'!a2:b940,2)
    >
    > Use the 'true' or 'false' if you really need to.
    >
    > hth
    > "JPriest" wrote:
    >
    >>
    >> So i'm attempting this one more time because i haven't been able to get
    >> it to work for me yet.
    >>
    >> Here's the situation:
    >>
    >> I want to find the value in sheet1b2 in sheet2 col b and return the
    >> value in sheet2 col a to an empty cell in sheet 1
    >>
    >> here's the formula i have tried and gotten an NA# error
    >> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
    >> This formula i've gotten from the excel help file and doesn't work for
    >> me.
    >>
    >> Can someone please help??!
    >>
    >> Thanks in advance,
    >> Jeff
    >>
    >>
    >> --
    >> JPriest
    >> ------------------------------------------------------------------------
    >> JPriest's Profile:
    >> http://www.excelforum.com/member.php...o&userid=24695
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=400874
    >>
    >>




  119. #119
    Domenic
    Guest

    Re: vlookup help

    Try...

    Sheet1!C1, copied down:

    =INDEX(Sheet2!$A$1:$A$100,MATCH(B1,Sheet2!$B$1:$B$100,0))

    Adjust the range accordingly.

    Hope this helps!

    In article <JPriest.1uncyj_1125522347.716@excelforum-nospam.com>,
    JPriest <JPriest.1uncyj_1125522347.716@excelforum-nospam.com> wrote:

    > Stumped!!
    >
    > I've tried everything you guys through at me and nothing works, I get
    > the error!
    >
    > I hope I have explained everything correctly, but I will rephrase.
    > in colb of sheet 1 I have urls that I need to update. I would like to
    > search through sheet2 colb (contains the corresponding urls) and insert
    > the hit count (located in col a of sheet 2) into a cell in sheet1.
    > The hits are sorted into an ascending order. I can re-order the list if
    > i need to.
    >
    > I have tried all of the suggestions that all of you have given me to no
    > avail.
    >
    > Any suggestions?
    > Jeff


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1