Vlookup not returning all values

**vamshi57** · 02-13-2010, 04:43 PM

In the spreadsheet attached I have two tables , Raw table & Lookup table . I'm using Vlookup to return values . I'm not why all values are being returned .

In the same table in Column # AH , I'm seeing a different value being returned , I'm not sure why .Please help me with this .

**contaminated** · 02-13-2010, 05:01 PM

Think you can try this in AH4

=LOOKUP(99^99,CHOOSE({1,2},0,VLOOKUP($X4,OFFSET($B$3,,,COUNTA($C$4:$C$248),COUNTA($C$3:$Q$3)+1),16,0 )))

**vamshi57** · 02-13-2010, 05:07 PM

Thank you . If you look at the other columns , none of them are returning the values .Do you want me to use the same formula in those columns as well.

Also I would like to know why my vlookup is not working . Thanks in advance

**vamshi57** · 02-13-2010, 05:10 PM

I tried the formula you gave me .. but its not returning all the values . For ex # in AH 21 I'm expecting a value , but it didn't return any .

**contaminated** · 02-13-2010, 05:34 PM

Don't know why, but seems VLOOKUP sees some minor diffrence betweem values in P5 and X21. Copy P5 value onto X21, u'll get desired result
HTH

**whallgren** · 02-16-2010, 08:38 PM

The problem is being caused when any time ends in a repeating number (333 repeating or 666 repeating). To get around this, I added a round function to column A and did the same with column U. I did a quick sum to make sure total calls were the same on both tables.