Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a dynamic lookup and logical formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a dynamic lookup and logical formula
I think this addresses your question, though there may be a more elegant
solution that I'm not aware of: http://office.microsoft.com/en-us/as...orrespond ing "rwwkbw" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a dynamic lookup and logical formula
Your problem statement is confusing to me, since R63 is not "next it"
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 , rwwkbw wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
if logical test true, then hlookup, if false then difference betwe | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions |