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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
=vlookup(b2,'sheet2,a2:b940,1,false)
Try
=VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
Post back if that doesnt work,
Regards,
Alan.
"JPriest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
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
>
>
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" <[email protected]> wrote in
message news:[email protected]...
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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.
"pdberger" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
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 <[email protected]>,
JPriest <[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks