using vlookup

[gpeterman]

I am attempting to use Vlookup, but I don't think it will accomplish what I need.
I need to write a formula in a cell on sheet 1 to search down column A of sheet 1 and find numerical values which all start with the same 3 digits. Then find those values in column 1 on sheet 2 and return the information at that row from column 2 of sheet 2.
I am relatively a novice at these kinds of formulas.
Any help?

 

[SkipVought]

Hi,

find numerical values which all start with the same 3 digits

Do you mean that if the find value is 123 that ANY of these values would be included...
[tt]
1234
12345
123456
[/tt]
for instance?

Maybe if you posted some actual values and an example of yout results you expect, includeing the other information.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[gpeterman]

OK here it is. The values I am interested in all start with 552 in sheet 1 column 1.I want to find those values on sheet 2 column 1 and display the names in their respective rows on sheet 1. The entries which start with anything other than 552 can be ignored or is ok to return an error.

 

[SkipVought]

I don't get it. NONE of the lookup values in sheet2 are in sheet1???

Yes ALL the lookup values in sheet2 column A start with 552, but SO WHAT! That's not how lookups work!

I think that you ought to explain what you are trying to accomplish.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[xlhelp]

=VLOOKUP(A2,Sheet2!A1:B3,2,FALSE) should work. But, you have another problem. Some of the numbers are text. You cannot compare numbers against text. I suggest clear formats in column A in both the sheets.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[gpeterman]

Thanks for your help. Finaly discovered my Formula was OK.When I imported the info from Access an extra leading "space" was entered in each cell down column A of sheet 1. Excel considers a leading space as valid text so it could not get resolve descrepancy, and returned an error message #N\A.