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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Can I add a formula or function to Vlookup? 1
Drop down list control value in vba 2
Vlookup and Countif 0
Autonumber field in Excel that behaves the same as Access 0
Excel - Wich Function should I use? 1
Conditional Formatting Based On Formula Values 2

Top