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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top