Forum Discussion
=lookup formula only retrieving part of my chart data. HELP!
So I am creating a list of names so that I can quickly input room assignments for students to report to on certain days. The idea is that I can type the letter "a" on a day next to a student's name a...
Detlef_Lewin wrote:Hello Andrew
Since your fomula is using the whole column Y for lookup, every entry in this column will be matched. There is probably some text down below.
Better restrict the formula to the actual cells.
=LOOKUP(D4,$Y$3:$Y$37,$Z$3:$Z$37)
Thank you so much for your help. I have tried limiting my formula to only Z3 to Z37 and Y3 to Y37, but it still gives me a zero value for v, w, x, y, z. I have tried moving my chart to different columns (Q, R, S) and still same issue. I even retyped the chart from scatch. It still gives me the 0 value for v-z. Getting frustrated, lol.
Hi Andrew,
If you attach your file removing all unnecessary information it'll much easier to help.