I'm trying to write a formula that would do the following between two
sheets:
In Sheet 1 Reference the text in a cell - I'll call it B4
Look at at cells "Sheet2!$R$59:$FZ$69" (yes, I need an absolute
reference because I intend to drag the formula) to see if a match to
"Sheet1!B4" is in that range
Then, report the data that is found in the cell next it. (so if a match
to "Sheet1!B4" is found in "Sheet2!R61" then report "Sheet2!R63 in the
cell).
It strikes me as pretty easy, but I cannot get it to work. I'm trying
to make quick work of an enormous sheet, but I cannot figure out what
type of dynamic formula to write. Please help!
--
rwwkbw
------------------------------------------------------------------------
rwwkbw's Profile:
http://www.excelforum.com/member.php...o&userid=33002
View this thread:
http://www.excelforum.com/showthread...hreadid=528263