LinkBack URL
About LinkBacks
Hello, my problem is that:
In Matrix spreeshet i select the product (in yellow) and i need that the colunm Name and Number be filled with the names in spreeshet TABELA and the respectives colours.
Folha2.xlsx
Thks a lot
VlOOKUP with 2 conditions
Hello, my problem is that:
In Matrix spreeshet i select the product (in yellow) and i need that the colunm Name and Number be filled with the names in spreeshet TABELA and the respectives colours.
Folha2.xlsx
Thks a lot
I'm having a hard time understanding what you're looking for. Could you add an "After" example so show what the spreadsheet should look like after the VLookup?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Folha2.xlsx
Try now, and thks for the attencion
you can help me?
Named Ranges added:
DropDown Validation List:
Lion, Bocas De Carga, Beru
Formula fill in After I6:U23
Note, used SUBSTITUTE to remove spaces from product name to match range names
Please Login or Register to view this content.
Ben Van Johnson
Hello, great work but i need that the names apear and desapear if the name have or not colors in the selected product. And i need that is possible add product in the table and the formula works without changing nothing. Itīs possible?
Thks
Hi
Used helper column in tabela sheet
Uploaded the file
Have a look
Appreciate the help? CLICK *
Thks for help me, the return result is not OK, i dont now how but is incorretand if i need to add a new prouct? e need to edit the formulas?
yes you should edit the formula. Referenced area in formula is constant. If you want to add new products you should edit the formula and enlarge its referred area. Its up to you how large this area will be. You should consider to be added products in future.
Ok, but the sheet you send me is not OK, is not importing the value correct, compare wth the table
Yes you were right. Sorry for that. Paste below formula to I6 cell and drag it right-down. Enter Ctrl+Shift+Enter after pasting the formula.Originally Posted by SaPires
=IFERROR(INDEX(TABELA!$C$3:$O$21,MATCH(AFTER!$E6,TABELA!$B$3:$B$21,0),MATCH(1,($O$4=TABELA!$C$1:$O$1)*(AFTER!I$5=TABELA!$C$2:$O$2),0)),"")
Perfect, thks a lot
You are welcome. Thank you for feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks