Formula to get text from multiple cells in Excel 2007

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to get text from multiple cells in Excel 2007

11-13-2018, 04:20 PM

xor

Windows 10 Formula to get text from multiple cells in Excel 2007

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

Marcia, IFERROR was new in Excel 2007 and it works fine with both INDEX and MATCH.

If you don't want or can't use IFERROR then use =IF(ISERROR(....

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Formula to extracting text from text string	Haha88	Excel	9	02-05-2018 01:04 AM
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
If text in column then formula in other	Grubermen	Excel	1	09-06-2017 06:35 AM
Editing the text a formula gets me	Jiing Chiang	Excel	7	02-08-2016 10:01 PM
extract text with formula	s7y	Excel	7	06-05-2013 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:04 AM.