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" 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

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

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

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