LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default vlookup glitch

Using po numbers in column A produces the serial numbers in column B. The
issue is the PO numbers are the same but the serial numbers are unique. The
vlookup function is only pulling the first po lookup line for the serial
number. The results for serial numbers are all the same and not unique
numbers.
Column A1 to A10 same po 456890 - Column B B1-B10 serial numbers are all
unique. Results for Column B is always B1. The serial numbers b2 to b10 are
never pulled.








































































 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another odd VBA glitch in 2007 teepee Excel Discussion (Misc queries) 4 April 1st 07 09:16 PM
Formula Calculation Glitch? Jake Excel Discussion (Misc queries) 3 September 16th 06 05:15 PM
Pivot Table Glitch? [email protected] Excel Discussion (Misc queries) 2 September 12th 06 06:57 PM
Excel function glitch? bdog Excel Worksheet Functions 1 April 11th 06 06:01 PM
EXCELL 2002 Glitch???? Gabriel20783 Excel Discussion (Misc queries) 1 November 29th 04 08:55 PM


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"