Forum Discussion

Copper Contributor

Mar 27, 2017

=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...

excel

Formulas and Functions

Detlef_Lewin

Silver Contributor

Mar 27, 2017

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)

Andrew Statt
Copper Contributor
Mar 27, 2017
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.
- SergeiBaklan
  Diamond Contributor
  Mar 28, 2017
  Hi Andrew,
  
  If you attach your file removing all unnecessary information it'll much easier to help.