Need some help returning a value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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
work***
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
work***, then a list of zip codes and a coresponding value for those
zipcodes on another work***, 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?action=getinfo&userid=24931
View this thread: http://www.excelforum.com/showthread.php?threadid=384672

.

Quantcast