| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
I am looking for a formula that is very similar to sumif - except I do not
what to sum the values - i just want to display the value or text that is contained in another cell on the sam row that the name is on. for example: a1:a3 = joe, jane, rick b1:b3 = 10,11,na if "jane", then 11 sumif works if it's a value but how do I handle if "rick" then na? I hope this makes since. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
Try this:
D1 = jane =VLOOKUP(D1,A1:B3,2,0) Biff "RAZ" wrote in message ... I am looking for a formula that is very similar to sumif - except I do not what to sum the values - i just want to display the value or text that is contained in another cell on the sam row that the name is on. for example: a1:a3 = joe, jane, rick b1:b3 = 10,11,na if "jane", then 11 sumif works if it's a value but how do I handle if "rick" then na? I hope this makes since. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
Perfect- thank you "RAZ" wrote: I am looking for a formula that is very similar to sumif - except I do not what to sum the values - i just want to display the value or text that is contained in another cell on the sam row that the name is on. for example: a1:a3 = joe, jane, rick b1:b3 = 10,11,na if "jane", then 11 sumif works if it's a value but how do I handle if "rick" then na? I hope this makes since. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
You're welcome. Thanks for the feedback!
Biff "RAZ" wrote in message ... Perfect- thank you "RAZ" wrote: I am looking for a formula that is very similar to sumif - except I do not what to sum the values - i just want to display the value or text that is contained in another cell on the sam row that the name is on. for example: a1:a3 = joe, jane, rick b1:b3 = 10,11,na if "jane", then 11 sumif works if it's a value but how do I handle if "rick" then na? I hope this makes since. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| HOW? Find and display the last cell in a column with a value 0 | Excel Discussion (Misc queries) | |||
| how to display the column or cell the MIN() result came from? | Excel Worksheet Functions | |||
| Display row & column number in cell | Excel Worksheet Functions | |||
| how to display heading of column corresponding to the cell | Excel Worksheet Functions | |||
Linear Mode
