Vlookup execution or slow response

You have the option for "Show formulas instead of their results". I had to remove it just to look at your results.

Can you describe a little more about what you mean by "execution is sporadic"? If you type in one Variant number, does it take a few seconds for the formulas to update?

This is a macro-enabled file, but there is no code, so that is not causing a problem.

Are you using Excel on your desktop or online?

I am not experiencing any problems. This is a pretty straightforward workbook and there is nothing in here that should cause performance problems. I pasted in 25 Variants at one time and it updated instantly.

Could there be something else running on your computer hogging resources?

Your file took way longer to open than normal.

I copied 29 variants across and it took maybe a second to calc.
I also used the same variant, pasted it 29 individual times, and while not instant, the calcs were almost normal.

Some changes I made to your file...
1. Make sure your headings match exactly. If you need to go across rows in a single cell, use Wrap Text, dont add extra spaces.

2. changed vlookup to INDEX/MATCH
=IFERROR(INDEX('Price Table'!$A$2:$L$147,MATCH($B5,'Price Table'!$A$2:$A$147,0),MATCH(E$3,'Price Table'!$A$1:$L$1,0)),"")

3. Not sure why you need to have M, O and P as text, but you could add TEXT() to my INDEX/MATCH for that, and eliminate S:U altogether

4. Put =TODAY() in it's own cell, and reference that, instead of the constant use of =NOW() (I put it in A1)
Then P5=TEXT(IF(N5>O5,$A$1,""),"mm/yyyy")

5. Finally, change your formula to...
=IF($B5="","",INDEX('Price Table'!$A$2:$L$147,MATCH($B5,'Price Table'!$A$2:$A$147,0),MATCH(E$3,'Price Table'!$A$1:$L$1,0)))

This will speed up your file considerably.

E$3 is the column heading. It changes the col letter to F$3, G$3 etc as you copy the formula across, but but does not change the row number as you copy down.

I have included the changes I suggested in the attached file, they all seem to work for me?

Also, because you dont actually have any macros. I saved the file with a .xlsx extension

Jeff - speed king? lol
thanks for the rep

I have also suffered a lot from the slow response of my Windows 10. I have also reset the system to make it fast, but it also failed to speed up the system. Finally, epson error code 0xf4 solved the issue and I just followed the methods that are mentioned over there and it really worked on my system.