| If the comments are Texts then use the below formula:-
=IF(A1="","",IF(ISNA(VLOOKUP(A1,Product01!A:B,2,FALSE)),"",IF(VLOOKUP(A1,Product01!A:B,2,FALSE)=0,"","["&VLOOKUP(A1,Product01!A:B,2,FALSE)&"]
"))&IF(ISNA(VLOOKUP(A1,Product02!A:B,2,FALSE)),"",IF(VLOOKUP(A1,Product02!A:B,2,FALSE)=0,"","["&VLOOKUP(A1,Product02!A:B,2,FALSE)&"]
"))&IF(ISNA(VLOOKUP(A1,Product03!A:B,2,FALSE)),"",IF(VLOOKUP(A1 |
|
 |
|
 |
Group: microsoft.public.excel.misc · Group Profile · Search for Product03 in microsoft.public.excel.misc
Author: Ms-Exl-Learner
Date: May 13, 2010 18:59
Try this. Somewhere on the worksheet list your three lookup worksheets Product01, Product02, Product03. Select the three cells and in the name box name them MySheets. They will now be included in the formula. Enter the formula where you want the answer to be using Ctrl + Shift + Enter. You will get { } around the formula. This called Array-Enter. If you change the formula you will
|
