=VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045)
I am trying to find a reference number in the 4th column (D) that belongs to
an item number that I am entering into the lookup cell (G2)...I know the item
number is in the column that contains all the item numbers. There are
entries up to row 2045, and there are 4 columns.

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