Hey all,
currently trying to combine some text together from multiple worksheets based on VLOOKUP
what I have so far, only returns the first valid result to the cell with the formula - how can I combine the results?
My formula is =IFERROR(VLOOKUP(Raw!A1,Sheet2!$A:$F,4,)IFERROR(VLOOKUP(Raw!A1,Sheet3!$A:$F,4,)IFERROR(VLOOKUP(Raw!A1,Sheet4!$A:$F,4,))))
This currently skips sheet2 which is empty (intended), captures the data in sheet3 but stops there and does not capture the data in sheet 4.
I'm using Excel 2010, should probably also mention, this will likely extend to further worksheets in time
currently trying to combine some text together from multiple worksheets based on VLOOKUP
what I have so far, only returns the first valid result to the cell with the formula - how can I combine the results?
My formula is =IFERROR(VLOOKUP(Raw!A1,Sheet2!$A:$F,4,)IFERROR(VLOOKUP(Raw!A1,Sheet3!$A:$F,4,)IFERROR(VLOOKUP(Raw!A1,Sheet4!$A:$F,4,))))
This currently skips sheet2 which is empty (intended), captures the data in sheet3 but stops there and does not capture the data in sheet 4.
I'm using Excel 2010, should probably also mention, this will likely extend to further worksheets in time