if single product code have descriptions more than one e.g (According to this video) product code 10690 has description Laminate Color Or 02 if same code has description Laminate Color Or 02A, 02B,..... what would be the formula ???
I could not get my follow-along if-statement to work. I'm using Excel 2010, but I don't think that makes a difference. I went over it thoroughly several times and would be very appreciative if someone is able to find the error. The following is my code: If statement: =IF(VLOOKUP($B$16,Customers!$A$2:$K$5,5)="yes",VLOOKUP($A20,Table3,6),VLOOKUP($A20,Table3,4)) No discount: VLOOKUP($A20,Table3,4) Discount: VLOOKUP($A20,Table3,6) A few key notes: Account number for the instructor's invoice table is his C17; mine is B16. His Customer sheet goes A2 to G5, mine is A2 to K5 (I already added state, zip and phone number columns), The check is in Column 5, which is the E column of the customers table (same as the instructor's). My catalogue table goes from A2 to F17 Table3 refers to the Catalogue table. My customers table is Table2, but I decided to name it in the formula. When I am entering different account numbers in B16 of the invoice page, the table beneath does not respond to the changes.
This is even better than going to class, It's very easy to understand....Thanks
+Alieu M. kenneh Thanks for the kind comments ;-)
Thank you so much, Mr. Simon
...just when I needed it...better than my teacher :) ...great stuff!! thanks!
Eddie MEGAO Thanks for the comments and for watching!
This is just brilliant... wonderfully explained.....
+Vivek Anand Thanks for the kind comments!
This is a great tutorial video...please keep up the great work.
easy to listen to , very concise , Excel training at it's best , nice work Simon.
+Cyber Spook Thanks for the positive comments and for watching!
You are so Helpful!!! Thanks Mr. Simon,,,:)
Thanks Mr simson
Wonderful sir
Great video !
Faiyaad Alam Glad you enjoyed it!
This is really a helpful content.Sir Do u provide online classes?
It would be really helpful if you'd put the file in the description so we could learn it practically.
if single product code have descriptions more than one e.g (According to this video) product code 10690 has description Laminate Color Or 02 if same code has description Laminate Color Or 02A, 02B,..... what would be the formula ???
rather than using the absolute or relative reference for cells, it could have been better if you create named ranges and then use those in formulas...
I could not get my follow-along if-statement to work. I'm using Excel 2010, but I don't think that makes a difference. I went over it thoroughly several times and would be very appreciative if someone is able to find the error. The following is my code:
If statement:
=IF(VLOOKUP($B$16,Customers!$A$2:$K$5,5)="yes",VLOOKUP($A20,Table3,6),VLOOKUP($A20,Table3,4))
No discount:
VLOOKUP($A20,Table3,4)
Discount:
VLOOKUP($A20,Table3,6)
A few key notes:
Account number for the instructor's invoice table is his C17; mine is B16.
His Customer sheet goes A2 to G5, mine is A2 to K5 (I already added state, zip and phone number columns),
The check is in Column 5, which is the E column of the customers table (same as the instructor's).
My catalogue table goes from A2 to F17
Table3 refers to the Catalogue table. My customers table is Table2, but I decided to name it in the formula.
When I am entering different account numbers in B16 of the invoice page, the table beneath does not respond to the changes.
Adding the VLookup makes this frustrating and annoying for people only trying to understand the if function
*****
For some it does make it more difficult.
+C00kii0 totally agree. I just wanted to know how the if function works. most of this video was about that vlookup function. Completely useless video.