Dougie1
Board Regular
- Joined
- Jul 27, 2007
- Messages
- 212
Morning all,
Using Excel 2007.
Is it possible to combine a text value and a vlookup into a single cell ?
By way of example what I have at the moment is the text "Batch 1:" in cell A10 and a lookup in cell B10 which pulls through a comment on Batch1 from another source.
The problem is that cells A1 to A8 contain further text in each cell. Now this text is a lot longer than Batch 1 but it still needs to be seen.
So what I have is :
Batch 1: Then the result of my look up further over the sheet than I would like (it amounts to about 30 spaces away).
So, I was wondering if it is possible to combine the text Batch 1: and the vlookup into the same cell?
All help appreciated.
TIA
D
Using Excel 2007.
Is it possible to combine a text value and a vlookup into a single cell ?
By way of example what I have at the moment is the text "Batch 1:" in cell A10 and a lookup in cell B10 which pulls through a comment on Batch1 from another source.
The problem is that cells A1 to A8 contain further text in each cell. Now this text is a lot longer than Batch 1 but it still needs to be seen.
So what I have is :
Batch 1: Then the result of my look up further over the sheet than I would like (it amounts to about 30 spaces away).
So, I was wondering if it is possible to combine the text Batch 1: and the vlookup into the same cell?
All help appreciated.
TIA
D