# Vlookup Not Working Properly

1. ## Vlookup Not Working Properly

hi all....

i have use formula like this :
``Please Login or Register  to view this content.``
that formula not properly working....
my target is red background
name sheet "LAP REVAL" in L161,L163,L165, etc...down..
my data in sheet "Input Lap" in column BO,BP,BQ down...

that my attachment file :

how to fix it? and make easy suitable range/cell if necessary...

2. ## Re: Vlookup Not Working Properly

Hope this helps

3. ## Re: Vlookup Not Working Properly

Would it not be
``Please Login or Register  to view this content.``
and
Formula:
`Please Login or Register  to view this content.`

4. ## Re: Vlookup Not Working Properly

@Azumi - Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

5. ## Re: Vlookup Not Working Properly

hello all...

i think that not simple like it....
in cell L161, L188, L215, ETC....{StreetA,StreetB, StreetC.......}..
How to make it...copy formula not type manual range/cell

6. ## Re: Vlookup Not Working Properly

somebody would help me...

7. ## Re: Vlookup Not Working Properly

It is not clear (to me) what your formula (the double VLOOKUP) is doing

=VLOOKUP(VLOOKUP(\$N\$2;'Input Lap'!\$A:\$BV;INT((ROWS(\$1:41)-1)/28)+28;FALSE);'Input BGN'!\$A:\$BV;67;FALSE)

The first VLOOKUP returns 7

and the second the value in Row 8, column BO from "Input BGN"

BUT you should be returning the second value from "Input Lap' ????

VLOOKUP is working correctly as defined by your parameters: so check your logic.

8. ## Re: Vlookup Not Working Properly

thank you John...would you help me ,how to make more simple from that's formula above..

9. ## Re: Vlookup Not Working Properly

hi Jhon Topley...
``Please Login or Register  to view this content.``
not work for me..

10. ## Re: Vlookup Not Working Properly

In what way does it not work for you? Incorrect results? Error message? What?

11. ## Re: Vlookup Not Working Properly

What does not work mean???

We cannot help you as we do not know what you require the formula to do (in business terms).

What are you trying to "lookup" based on what criteria? The first VLOOKUP simple returns a value between 1 and 20 BUT only from row 1 of "Input Lap"

and this value (7 in your case) is used to match against column A of "Input BGN" to find value in column "BO" (column 67).

##### Users Browsing this Thread

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

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1