software

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(...)amp;quot;-quot;amp;VLOOKUP(...)

HTH
--
AP

quot;chrisquot; gt; a écrit dans le message de
...
gt; Hi there,
gt;
gt; I was wondering if its possible to have 2 formulas in one cell.
gt;
gt; Such as vlookup one value and then vlookup another value and display both
gt; results in one cell.
gt;
gt; Thanks
Hi

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

Andy.

quot;chrisquot; gt; wrote in message
...
gt; Hi there,
gt;
gt; I was wondering if its possible to have 2 formulas in one cell.
gt;
gt; Such as vlookup one value and then vlookup another value and display both
gt; results in one cell.
gt;
gt; Thanks
Thats brilliant.

thank you very much

Regards
Chris

quot;Andyquot; wrote:

gt; Hi
gt;
gt; Just join the two VLOOKUPs with amp; or amp;quot; quot;amp; if you want a gap in
gt; between. You could also use a slash, colon etc.
gt;
gt; Andy.
gt;
gt; quot;chrisquot; gt; wrote in message
gt; ...
gt; gt; Hi there,
gt; gt;
gt; gt; I was wondering if its possible to have 2 formulas in one cell.
gt; gt;
gt; gt; Such as vlookup one value and then vlookup another value and display both
gt; gt; results in one cell.
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;

Thats brilliant, thank you very much

Regards

Chris

quot;Ardus Petusquot; wrote:

gt; You cane use:
gt; =VLOOKUP(...)amp;quot;-quot;amp;VLOOKUP(...)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;chrisquot; gt; a écrit dans le message de
gt; ...
gt; gt; Hi there,
gt; gt;
gt; gt; I was wondering if its possible to have 2 formulas in one cell.
gt; gt;
gt; gt; Such as vlookup one value and then vlookup another value and display both
gt; gt; results in one cell.
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;