You only need to post your question once. :)
I've already answered this with VLOOKUP.
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"rcarrollct" wrote
in message ...

Ok, here's the issue, i'm trying to create a formula, that will
a) look at the value of a specific cell
b) find that exact value in a defined column, on a diffferent
worksheet
c) return the value in the column and cell next to the found value


is that at all possible???

in english, i have a list of zip codes with other info on one
worksheet, then a list of zip codes and a coresponding value for those
zipcodes on another worksheet, and i need to match the coresponding
number to the zipcodes on the first page.... I don't know if that
explination helped but it makes sense in my head... I really could use
some help... if anyone can understand what I'm trying to do


Thanks
Ryan


--
rcarrollct
------------------------------------------------------------------------
rcarrollct's Profile:
http://www.excelforum.com/member.php...o&userid=24931
View this thread: http://www.excelforum.com/showthread...hreadid=384672