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

C

chris

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
 
G

Guest

Hi

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

Andy.
 
Top