I have tried that, and still am not getting a value returned. The value
being looked up is in the 1st column. I can't for the life of me figure out
what is wrong...and it's probably very simple and right in front of me.

What if I e-mail a file?
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle


"John C" wrote:

=VLOOKUP(value,table,column,FALSE/TRUE)
value is the value you are looking up, G2
Table is the data table you are looking at, of which the first column MUST
be where your value(s) will be.
column is the column number as determined by your table, that you need
FALSE=exact match and TRUE= near match(and table must be sorted).
so
=VLOOKUP(G2,$B$1:$E$2045,3,FALSE)

HTH.
--
John C


"Richard Champlin" wrote:

=VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045)
I am trying to find a reference number in the 4th column (D) for an item
number which is in the 2nd column. I've entered the number into the G2
location, and I know the number is in the 2nd column....but it is not
working. There are values listed up to row 2045.
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle


"Mike H" wrote:

Maybe we could see this formula

"Richard Champlin" wrote:

I am trying to copy a vLookup that I created in one spreadsheet into another
so that I can simply tailor it to the new spreadsheet. No matter what I try,
it does not return anything other than "#VALUE!" I think I am unclear as to
the parameters.

--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle