Looking for the function to compare the value in the column on sheet T1 column A to Sheet Parameter, col B,
If the value in colb = T1!A then return the value in Column E of a -1.
Have loop thru to determine which Parameters are OptLimit in the Parameter sheet.
I am rusty in Excel functions.
What is the proper syntax - I thought Vlookup would do it, need help.