Concatenate?

  • Thread starter Thread starter George Gee
  • Start date Start date
G

George Gee

Hi all

I have the following formula in M28
=IF(J22="","",VLOOKUP(J22,'Tick Sheet'!G4:T3000,13,FALSE))

This works fine.

Is it possible to search both columns 13 *&* 14,
and display the results in M28 side by side (concatenate)?
 
Hi

Try this:
=IF(J22="","",VLOOKUP(J22,'Tick Sheet'!G4:T3000,13,FALSE)&VLOOKUP(J22,'Tick
Sheet'!G4:T3000,14,FALSE))
If you want a space in between the returned values, change the & in the
middle to &" "&
 
Hi Andy

Thanks for the reply, however:
I'm getting #N/A error in M28
Both the following formulae work OK: (on their own)

=IF(J22="","",VLOOKUP(J22,'Tick Sheet'!G4:T3000,13,FALSE))
=IF(J22="","",VLOOKUP(J22,'Tick Sheet'!G4:T3000,14,FALSE))

Any thoughts?

George Gee

*Andy B* has posted this message:
 
Hi Andy

Have solved the problem!

I copied the formula that you gave me, and pasted it into my workbook,
this, as I pointed out gave an error: #N/A.

When I tried to open the workbook, after having closed it, I kept getting a
dialogue box telling me that the workbook was linked to another, and would
I like to update........ etc.

I deleted the formula from M28, and manually typed it in.
Everything is now fine!

Any explanation?

George Gee


*George Gee* has posted this message:
 
Hi

The only thing I can think is that some extraneous characters were pasted in
along with the formula!
 
George,


=IF(J22="","",VLOOKUP(J22,'Tick Sheet'!G4:T3000,13,FALSE))
&IF(J22="","",VLOOKUP(J22,'Tick Sheet'!G4:T3000,14,FALSE))
 
Back
Top