Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use & with two formulas
With these two formulas, I can make them work okay if I select four cells and enter a formula and array enter. Select four more cells and do the same with the second.
Where A2 holds 4,6 =VLOOKUP(--LEFT(A2,1),A4:P9,{2,3,15,16},0) =VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0) I thought I could select eight cells and enter the formulas as: =VLOOKUP(--LEFT(A2,1),A4:P9,{2,3,15,16},0)&VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0) When I use eight cells, the first formula seems to return its stuff and I get #N/A's for the second four cells. I've use & in the past and it worked, but here I am drawing a blank. Thanks, Howard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use & with two formulas
Hi Howard,
Am Fri, 12 Jul 2013 11:31:09 -0700 (PDT) schrieb : =VLOOKUP(--LEFT(A2,1),A4:P9,{2,3,15,16},0) =VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0) what do your want to do? Select 4 cells and try: =VLOOKUP(INT(A2),A4:P9,{2,3,15,16},0)&"/"&VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use & with two formulas
On Friday, July 12, 2013 11:55:59 AM UTC-7, Claus Busch wrote:
Hi Howard, Am Fri, 12 Jul 2013 11:31:09 -0700 (PDT) schrieb : =VLOOKUP(--LEFT(A2,1),A4:P9,{2,3,15,16},0) =VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0) what do your want to do? Select 4 cells and try: =VLOOKUP(INT(A2),A4:P9,{2,3,15,16},0)&"/"&VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0) Regards Claus B. Whoa!! That result was unexpected, I had it in my mind that the eight return values would be in eight separate cells. In four cells is fine along with the / between. And now that I reflect on it this is pretty much what was returned in my claim of having used & with two formula similar to this before. Thanks, Claus. Regards, Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming |