VLOOKUP Problem

[ckrogers]

Hello. I'm trying to find out if a cell value is on another sheet on my
workbook. I'm using the VLOOKUP function

=VLOOKUP(G28,'FILE-DSPF'!H24:H27,7,0)

Column "7" in the third parameter will just return the cell value again ...
so I'm thinking if it's blank there was no match. The cell with the VLOOKUP
formula is formatted "GENERAL" ... but it's just displaying the formula, not
the result.

What am I doing wrong? Or is there a better way to do this?

Thanks for any and all help.

 

[Dave Peterson]

The lookup range in your formula is just a single column and you're trying to
retrieve the 7th column in that range.

So you'd want to expand that range to be at least 7 columns, maybe...
=VLOOKUP(G28,'FILE-DSPF'!H24:N27,7,0)

=========
But if you're really trying to see if that value in G28 matches the value in
H24:H27 of sheet File-dspf, you could use:

=isnumber(match(g2,'file-dspf'!h24:h27,0))

You'll see true if there is a match, false if there is no match.