Excel - Need help with lookup
Asked By Dan B
06-Nov-09 05:23 PM
Hi,
I have four columns of data. Column B is a list of names. I need a formula
that will like for a specific name in column B and give me the data on the
rows in columns A, C and D where it finds that name. Kind of like
sub-totalling by name in column B, but I want to duplicate the data to
another section of the spreadsheet.
Thanks for any help,
Dan
Dave Peterson replied to Dan B
=index('sheet2'!a:a,match(x99,'sheet2'!b:b,0))
Change x99 to the cell that contains the name.
Change 'Sheet2' to the name of the sheet with the table.
Change A:A to C:C and D:D for the other columns.
--
Dave Peterson
Dan B replied to Dave Peterson
Awesome, that worked.
Thanks a ton!
IF(MOD(ROW(B10:B34), 12) = 10, IF(B10:B34<> 0, B10:B34))) - - Jacob That worked. Thanks!! Thanks again. One more question. . .Is there any easy way to hide a "#DIV / 0 B10, B22, B34) / INDEX(FREQUENCY((B10, B22, B34), 0), 2), "") - - Biff Microsoft Excel MVP That worked. Thanks! You're welcome. Thanks for the feedback! - - Biff Microsoft Excel MVP keywords: Average, Function, that
1) Excel 2007 (1) Worksheet (1) ISNUMBER (1) CLEAN (1) TRIM (1) Hear.Gordwrote (1) Worked.Thanks (1) Are your number really numbers? In an adjacent column enter = ISNUMBER(B1) Copy down Edit> Replace What: Alt + 0160(on the numpad) With: nothing Replace all. Gord Gord: It worked. Thanks, Bill Good to hear. Gord e umn gives B t. It d t in r
guess. . . In the validation setup wizard uncheck "Ignore blank". - - Biff Microsoft Excel MVP Your suggestion worked! Thanks. Although I still know understand why the analogous formula-based validation in column C, with Excel that you remember once you have encountered it. - - Biff Microsoft Excel MVP Your suggestion worked! Thanks. Although I still know understand why the analogous formula-based validation in column C, with
B13) - - Biff Microsoft Excel MVP Best way, IMO. - - Regards Dave Hawley www.ozgrid.com It worked. Thanks so much T. Valko. :) You're welcome. Thanks for the feedback! - - Biff Microsoft Excel MVP It worked. Thanks so much T. Valko. :) keywords: Help, with, Conditional, SUMIF, Formula description: Hi, I would like
Excel MVP This worked! Had to uncheck, and then check Worksheet Menu Bar, but it worked. Thanks Bob I for your help! Actually the Toolbars, Customize, Worksheet Menu, Reset trick worked, but I appreciate your taking the time to try to help me out. Thanks Bob! It worked! Thanks so much for your help Gord! You're welcome, have a great day! Of course