Skip to Content
avatar image
Former Member

Lookup issue

I am editing a report that is attached to two excel spreadsheets that are extractions from my ERP system. The one spreadsheet contains a list dates, users, files that were changed, etc. From one of these fields I am able to extract a string of a file name that I need to associate to a program description. The second spreadsheet contains a list of file names with their corresponding program description. I have tested to the point that I know the string is pulling the correct file name but cannot get any information from the second spreadsheet. Here is the string I am using:

if{Sheet1_.Change From} <> "" and right({Sheet1_.Key},instr(strreverse({Sheet1_.Key}),"|")-1) = {data.Program Name} then
formula = {data.Program Description}
else
formula = ""
end if

What am I missing?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers