Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of Indirect on two worksheets
Hello, I have two worksheets in one file. It is attached. What I am trying to do is insert a value from Sheet 1 on Sheet 2 if the last name and dob match from Sheet 1. I have a formula on Sheet2 but I know it's incorrect. I'm not sure how it should work. Thanks for any help, Wendi +-------------------------------------------------------------------+ |Filename: Forum help.zip | |Download: http://www.excelforum.com/attachment.php?postid=4262 | +-------------------------------------------------------------------+ -- wgechter ------------------------------------------------------------------------ wgechter's Profile: http://www.excelforum.com/member.php...o&userid=30799 View this thread: http://www.excelforum.com/showthread...hreadid=504606 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of Indirect on two worksheets
Wendi, Based on your column headings in sheet 2 I assume that indicates the value you are trying to pull from sheet 1. You could use this without the INDIRECT to get the Lvalue. =SUMPRODUCT(--(Sheet1!$B$2:$B$3=B2),--(Sheet1!$C$2:$C$3=C2),(Sheet1!$D$2:$D$3)) Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=504606 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of Indirect on two worksheets
Steve, That works perfectly!! Thanks so much. 2 days research summed up in a few minutes. Thanks again, Wendi -- wgechter ------------------------------------------------------------------------ wgechter's Profile: http://www.excelforum.com/member.php...o&userid=30799 View this thread: http://www.excelforum.com/showthread...hreadid=504606 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of Indirect on two worksheets
Wendi, Glad it was the right solution for you. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=504606 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use 2 worksheets in one formula with INDIRECT & VLOOKUP | Excel Worksheet Functions | |||
indirect cell reference using copies of worksheets in same workboo | Excel Worksheet Functions | |||
indirect function in different worksheets, losing my hair! | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions |