Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Problem
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Problem
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. ckrogers wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Worksheet Functions | |||
VLookUp problem | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) |