Forum Discussion
Problem with LOOKUPVALUE not searching multiple columns
Am I right in saying that I cannot use the same Search_ColumnName twice when using the LOOKUPVALUE function? I have 4 columns in one table with values that match the Search_ColumnName values in an...
Still no joy on this one so I ended up creating a conditional column, which also gave me errors until I added a character to the blank spaces in each column and then it gave me what I needed.