ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Use & with two formulas (https://www.excelbanter.com/excel-worksheet-functions/448991-use-two-formulas.html)

[email protected]

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


Claus Busch

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

[email protected]

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


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com