i've tried to implement this for the past 45 minutes or so, however it
not liking something.

I have the range on sheet B, which includes only the cells that hav
the ID numbers (in G7:G65) and the cells that have the values (i
K7:K65), named. The Values are 4 columns to the right of the I
numbers.

On sheet A i have the formula

=VLOOKUP(E13,rangeB,5,FALSE)

in the cells that i want the values from K to pull into, and I kee
getting a N/A error.
I've tried all sorts of changes and i can't figure out why its no
working. Probably missing something obvious.


Thoughts?

- Kevin

--
TheIconoclas
-----------------------------------------------------------------------
TheIconoclast's Profile: http://www.excelforum.com/member.php...fo&userid=3080
View this thread: http://www.excelforum.com/showthread.php?threadid=50470