Your formula is only looking at *one* row in the Tech_List sheet, Row7.

Your formula has *no* range to search, just a single line!

You must include the entire datalist so that the formula has a range to look
at ... for example:

=VLOOKUP(A7,Tech_List!A1:D100,2,0)
The final zero is equivalent to "False", meaning you're looking for an exact
match only.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Sullycanpara"
wrote in message
...

Unfortunately, good tip, didn't think to change that, but unfortunately
false didn't work. there has to be a way to tell the formula that it
needs to read the info from the row that the information in the A
column is giving it, but I'm not sure yet just how to tweak that ;)

Thanks again for your suggestion, anything else will be quickly tried
;)

Tim


--
Sullycanpara
------------------------------------------------------------------------
Sullycanpara's Profile:
http://www.excelforum.com/member.php...o&userid=35879
View this thread: http://www.excelforum.com/showthread...hreadid=556716