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
|