I am trying to get VLOOKUP function to lookup the particular day in a week from a measurement period chart where the measurement days are typed in as numbers with blank cells in between some of them and i can't get the formula to look it up because i get #REF! errors. Can someone help me please?

Please post an example of your data and the formula that you are trying to use. Click on the following line and read the instructions found via that link before posting your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History