Says Cells are Empty when they are Not

[hnhorner]

Hello - I keep trying to run a function but it's not working because it says the cells are empty. When I trace the cells, they trace to a cell that has a value! I don't understand why I keep getting this response. Screenshot attached. Any help would be greatly appreciated. Thank you!!

[JBeaucaire]

I cannot see the image, and I would most likely need to see a workbook to detect the problem.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[joeu2004]

Hello - I keep trying to run a function but it's not working because it says the cells are empty. When I trace the cells, they trace to a cell that has a value! I don't understand why I keep getting this response. Screenshot attached.

First, attaching an actual Excel file is much better than an image. There are a lot of subtleties that we cannot resolve from an image.

Second, if you are referring to the result of the IFERROR formula, it does not "say" cells are empty when they are not. It says there is no match or there is some other error, or the matched cell is empty.

It appears that you are trying to match city names (column G) with a mix of names (column Z). Perhaps there is indeed no match. Off-hand, I do not see a match in the image. (But the image is very limited.)

Another possible error: you match against the range Z2:Z334, but you index the range Z2:Z329. If the match occurs in Z330 to Z334, the INDEX expression returns an error.

Also, you match against $Z$2:$Z334, but you index $Z$2:$Z$329. Should the latter part of the match range be $Z$334?

Finally, it is suspicious that you reference G5 in a formula in row 8 (or later) and potentially the 4th row of a list of formulas. Not necessarily an error; just something you might need to reconsider.

FYI, I believe the formula can be simplified to:
=IFERROR(VLOOKUP(G5,$Z$2:$Z$334,1,0),"")