can I use 2 formulas in 1 cell and display both results

Hi there,

I was wondering if its possible to have 2 formulas in one cell.

Such as vlookup one value and then vlookup another value and display both
results in one cell.

Thanks

Hi

Just join the two VLOOKUPs with & or &" "& if you want a gap in
between. You could also use a slash, colon etc.

Andy.

"chris" <[email protected]> wrote in message
news:[email protected]...
> Hi there,
>
> I was wondering if its possible to have 2 formulas in one cell.
>
> Such as vlookup one value and then vlookup another value and display both
> results in one cell.
>
> Thanks

You cane use:
=VLOOKUP(...)&"-"&VLOOKUP(...)

HTH
--
AP

"chris" <[email protected]> a écrit dans le message de
news:[email protected]...
> Hi there,
>
> I was wondering if its possible to have 2 formulas in one cell.
>
> Such as vlookup one value and then vlookup another value and display both
> results in one cell.
>
> Thanks

Thats brilliant.

thank you very much

Regards
Chris

"Andy" wrote:

> Hi
>
> Just join the two VLOOKUPs with & or &" "& if you want a gap in
> between. You could also use a slash, colon etc.
>
> Andy.
>
> "chris" <[email protected]> wrote in message
> news:[email protected]...
> > Hi there,
> >
> > I was wondering if its possible to have 2 formulas in one cell.
> >
> > Such as vlookup one value and then vlookup another value and display both
> > results in one cell.
> >
> > Thanks
>
>
>

Thats brilliant, thank you very much

Regards

Chris

"Ardus Petus" wrote:

> You cane use:
> =VLOOKUP(...)&"-"&VLOOKUP(...)
>
> HTH
> --
> AP
>
> "chris" <[email protected]> a écrit dans le message de
> news:[email protected]...
> > Hi there,
> >
> > I was wondering if its possible to have 2 formulas in one cell.
> >
> > Such as vlookup one value and then vlookup another value and display both
> > results in one cell.
> >
> > Thanks
>
>
>