VLOOKUP Problem

  • Thread starter Thread starter ckrogers
  • Start date Start date
C

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.
 
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.
 
Back
Top