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

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

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

HTH
--
AP

"chris" a écrit dans le message de
...
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

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

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" wrote in message
...
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

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

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" wrote in message
...
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

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

Thats brilliant, thank you very much

Regards

Chris

"Ardus Petus" wrote:

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

HTH
--
AP

"chris" a écrit dans le message de
...
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