| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Columns, Return Content
I need a function to return the contents of a cell based on a number given in
column F. Here it is: A B C D E F * $ @ % # 3 (I would need column G to return @ since it's 3 columns over) ^ ! % # * 2 (I would need column G to return ! since it's 2 columns over) Does this make sense? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Columns, Return Content
Try this in g1
=CHOOSE(F1,A1,B1,C1,D1,E1) Mike "Leah G" wrote: I need a function to return the contents of a cell based on a number given in column F. Here it is: A B C D E F * $ @ % # 3 (I would need column G to return @ since it's 3 columns over) ^ ! % # * 2 (I would need column G to return ! since it's 2 columns over) Does this make sense? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Columns, Return Content
Hi Leah,
You could use OFFSET for this Enter =OFFSET(A1,0,F1-1,1,1) in column G Remember that A1 and F1 in this formula will need to be changed to the corresponding cells you are working on Alan -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200907/1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Columns, Return Content
Try this:
=INDEX(A1:E1,F1) Copy down as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Leah G" <Leah wrote in message ... I need a function to return the contents of a cell based on a number given in column F. Here it is: A B C D E F * $ @ % # 3 (I would need column G to return @ since it's 3 columns over) ^ ! % # * 2 (I would need column G to return ! since it's 2 columns over) Does this make sense? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Columns, Return Content
That didn't work. Should there be a : somewhere?
"Mike H" wrote: Try this in g1 =CHOOSE(F1,A1,B1,C1,D1,E1) Mike "Leah G" wrote: I need a function to return the contents of a cell based on a number given in column F. Here it is: A B C D E F * $ @ % # 3 (I would need column G to return @ since it's 3 columns over) ^ ! % # * 2 (I would need column G to return ! since it's 2 columns over) Does this make sense? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Columns, Return Content
This worked! Thanks so much!
"Alan McQuaid via OfficeKB.com" wrote: Hi Leah, You could use OFFSET for this Enter =OFFSET(A1,0,F1-1,1,1) in column G Remember that A1 and F1 in this formula will need to be changed to the corresponding cells you are working on Alan -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200907/1 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Columns, Return Content
That didn't work. Should there be a : somewhere? It works perfectly and no there shouldn't be a : somewhere Mike "Leah G" wrote: That didn't work. Should there be a : somewhere? "Mike H" wrote: Try this in g1 =CHOOSE(F1,A1,B1,C1,D1,E1) Mike "Leah G" wrote: I need a function to return the contents of a cell based on a number given in column F. Here it is: A B C D E F * $ @ % # 3 (I would need column G to return @ since it's 3 columns over) ^ ! % # * 2 (I would need column G to return ! since it's 2 columns over) Does this make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function to return date content of another cell | Excel Worksheet Functions | |||
| How do I compare two columns and return a number count | Excel Worksheet Functions | |||
| if range b6:n6 has no content, return A6 | Excel Worksheet Functions | |||
| how to compare cell content to a row pf data in excel and return . | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
