Vlookup
Closed
vishnugj
Posts
8
Registration date
Monday May 3, 2010
Status
Member
Last seen
April 14, 2015
-
Jun 15, 2010 at 11:07 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 03:59 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 03:59 AM
Related:
- Vlookup
- If iserror vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Automatically transfer data from one sheet to another ✓ - Excel Forum
- Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 16, 2010 at 03:59 AM
Jun 16, 2010 at 03:59 AM
One ugly way would be
=IF(ISERROR(VLOOKUP($O4,$A:$A,1,FALSE)),"",IF(VLOOKUP($O4,$A:$L,9,FALSE)="","",VLOOKUP($O4,$A:$L,9,FALSE)) & IF(VLOOKUP($O4,$A:$L,10,FALSE)="","", CHAR(10) &"English: " & VLOOKUP($O4,$A:$L,10,FALSE)) & IF(VLOOKUP($O4,$A:$L,11,FALSE)="","",CHAR(10) & "Maths: " & VLOOKUP($O4,$A:$L,11,FALSE)) & IF(VLOOKUP($O4,$A:$L,12,FALSE)="","", CHAR(10) & "Chemistry: " & VLOOKUP($O4,$A:$L,12,FALSE)) )
Dont forget to format the column to ensure that word wrapping is ON
Having said that. You are better off by using a formula based column to join all comments together and using that consolidated comments column in look up, You could use on a different sheet if you want or on a hidden column
=IF(ISERROR(VLOOKUP($O4,$A:$A,1,FALSE)),"",IF(VLOOKUP($O4,$A:$L,9,FALSE)="","",VLOOKUP($O4,$A:$L,9,FALSE)) & IF(VLOOKUP($O4,$A:$L,10,FALSE)="","", CHAR(10) &"English: " & VLOOKUP($O4,$A:$L,10,FALSE)) & IF(VLOOKUP($O4,$A:$L,11,FALSE)="","",CHAR(10) & "Maths: " & VLOOKUP($O4,$A:$L,11,FALSE)) & IF(VLOOKUP($O4,$A:$L,12,FALSE)="","", CHAR(10) & "Chemistry: " & VLOOKUP($O4,$A:$L,12,FALSE)) )
Dont forget to format the column to ensure that word wrapping is ON
Having said that. You are better off by using a formula based column to join all comments together and using that consolidated comments column in look up, You could use on a different sheet if you want or on a hidden column
