Re: Double lookup without using vlookup?


Hi,

Yes, there could be more than 1 entry per week. There are 185 rows
now, but that will grow with the number of orders. The number of
columns would be limited to 106 (one for each week for 2 years).


What I'm trying to get to is this:

............6/2.....6/9.....6/16.....6/23
A..........S1......S2......Test.....Paint
B....................S1.......S2......Test....
C..........S2......Test....Paint


And I can get the data like this:

.........6/2.......6/9.....6/16.....6/23
A........S1
C........S2
B...................S1
A...................S2
C....................Test
B.......................................Test
C............................Paint
A.......................................Paint


S1, S2 are assembly stations, as are Test and Paint



Biff Wrote:
Hi!

Is it possible to have more than 1 entry per week per code in column
A?

Like this:

.................6/2................6/9.................6/16
A.............xxx..............................................
D................................................................
A.............xxx..............................................
A..................................xxx.........................
A..................................xxx.........................

How many rows of data are there? How many columns?

Biff


[/color]


--
HBF
------------------------------------------------------------------------
HBF's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34019
View this thread: http://www.excelforum.com/showthread.php?threadid=552336

.

Relevant Pages

  • Re: Slow logon because of "Applying computer settings..."
    ... entry found ... RpcServerRegisterIfEx successful ... entry in profile list for existing local profile ... Scheduler skipped because both deleted and changed GPO lists are ...
    (microsoft.public.windows.server.active_directory)
  • Hey it worked!! autocomplete: account passwords not saved
    ... to new profile is ... you should see an entry ... >Please do not send email directly to this alias. ... >> AutoComplete Does Not Save Username and Password ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Windows registered name incorrect
    ... profile and copy the data from old to new profile: ... "Dick Ballard" wrote in message ... I got the Registered To: Name entry changed under My ... > registry even though I never used that as a user name. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: OpenMsgStore fails with MAPI_E_FAILONEPROVIDER
    ... It creates a dynamic profile and logs into ... Handle to parent window. ... // and getting the entry that corresponds to the new service. ... It then opens the message store using this function but it fails on ...
    (microsoft.public.win32.programmer.messaging)
  • OpenMsgStore fails with MAPI_E_FAILONEPROVIDER
    ... Exchange using JNI and MAPI. ... It creates a dynamic profile and logs into ... // and getting the entry that corresponds to the new service. ... It then opens the message store using this function but it fails on ...
    (microsoft.public.win32.programmer.messaging)