[SOLVED] Vlookup issue with content of a cell as a cell reference

English
#1

I have this vlookup formula:

=VLOOKUP(A27,Games.I120:N134,5,0)

A27 = some text
some text is in the array represented as a cell reference like =c120
I get a #N/A error
If I put the actual value in the cell “some text” it works but I want to use a cell reference there to show the text.

Nevermind I had a space in the reference that was causing the issue.

#2

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.