vlookup help

[JPriest]

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

Here's the situation:

I want to find the value in sheet1b2 in sheet2 col b and return th
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 fo
me.

Can someone please help??!

Thanks in advance,
Jef

 

[Alan]

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

Try

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

Post back if that doesnt work,
Regards,
Alan.

 

[Guest]

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

 

[kk]

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


message
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

 

[Alan]

Using '1' as the column to display in a VLOOKUP does work, pointless, but it
works,
Regards,
Alan.

 

[JPriest]

Stumped!!

I've tried everything you guys through at me and nothing works, I ge
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 t
search through sheet2 colb (contains the corresponding urls) and inser
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 i
i need to.

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

Any suggestions?
Jef

 

[Domenic]

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!