0

excel table as lookup

Jet Reports Historic Posts

June 11, 2010 16:45

None

Follow

I have a list of Document No.s & I'd like to look up their dimensions from the Posted Document Dimension table.
How do I use MY list of documents as the filter?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts June 14, 2010 08:20

  Hi,
  
  from which table do u extract the document no's?
  if this tabel contains the shortcut dimension fields jetreport creates automatically virtual dimension fields whith the name of the dimension.
  For example if u have dimension departmant u can get the field with =NF(C7;"Department") where c7 containt the =NL function to the document no.
  
  Hope to hepl i with this

• 0
  
  Jet Reports Historic Posts June 14, 2010 13:00

  Thanks.
  The list is in excel already. I need to reference this list to find each advanced dimension that is in the entry.
  For example, Doc No 123456 - NL("excel list", "Posted Document Dimension", "Dimension Value Code","Table ID","115","Dimension Code","CUSTDEPT").
  The excel list has 50+ document numbers & there are 11 Dimension Codes. I plan on just repeating the formula in 11 columns.
  But, how do I reference the list instead of a NAV table?

• 0
  
  Jet Reports Historic Posts August 27, 2014 18:08

  Would it make more sense to use vlookup's in this case sinse the data is in excel already?