Skip to Content
0

Lookup issue

Oct 11, 2017 at 12:26 PM

37

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers