software

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 quot;Sheet2!$R$59:$FZ$69quot; (yes, I need an absolute
reference because I intend to drag the formula) to see if a match to
quot;Sheet1!B4quot; is in that range

Then, report the data that is found in the cell next it. (so if a match
to quot;Sheet1!B4quot; is found in quot;Sheet2!R61quot; then report quot;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: www.excelforum.com/member.php...oamp;userid=33002
View this thread: www.excelforum.com/showthread...hreadid=528263I think this addresses your question, though there may be a more elegant
solution that I'm not aware of:

office.microsoft.com/en-us/as...orrespond ing

quot;rwwkbwquot; wrote:

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

Your problem statement is confusing to me, since R63 is not quot;next itquot;
from R61 in a way that I understand...

If you want to look up B4 in R59:R69, and return the value from the
corresponding cell in column S:

=VLOOKUP(Sheet1!B4,Sheet2!$R$59:$S$59, 2, FALSE)

In article gt;,
rwwkbw gt; wrote:

gt; I'm trying to write a formula that would do the following between two
gt; sheets:
gt;
gt; In Sheet 1 Reference the text in a cell - I'll call it B4
gt;
gt; Look at at cells quot;Sheet2!$R$59:$FZ$69quot; (yes, I need an absolute
gt; reference because I intend to drag the formula) to see if a match to
gt; quot;Sheet1!B4quot; is in that range
gt;
gt; Then, report the data that is found in the cell next it. (so if a match
gt; to quot;Sheet1!B4quot; is found in quot;Sheet2!R61quot; then report quot;Sheet2!R63 in the
gt; cell).
gt;
gt; It strikes me as pretty easy, but I cannot get it to work. I'm trying
gt; to make quick work of an enormous sheet, but I cannot figure out what
gt; type of dynamic formula to write. Please help!