Microsoft Office Forums - View Single Post - Formula to get text from multiple cells in Excel 2007

Thread: Formula to get text from multiple cells in Excel 2007

View Single Post

Old

11-13-2018, 04:20 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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(....

Reply With Quote