Hi to all experts. I am here again with my query & i hope i will get my solution, as i always have. So here is my query. In sheet1 there are quality section in column b and c1 d1 e1 f1 are sizes and below of them are prices.
I want that in billing sheet. As i enter quality name & size price sholud be taken automaticaly.
A single quality have many sizes according to their price.
So please make it solved.
hi there. try this formula in cell C3:
=IFERROR(1/(1/VLOOKUP($B3,Sheet1!$B:$F,COLUMNS(BILLING!$B$3:C3),0)),"")
copy down and across.
i developed a tool to help people learn VLOOKUP. try downloading this file here:
https://www.excelforum.com/tips-and-...-how-tool.html
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Benni Can you please explain why you two times divided as it can easily retrieve the result?
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
I think to mask "0" values
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Its my pleasure that you have replied to my post.
But this in not working. I think that some kind of formula should be applied in d3. Because every quality has 4 sizes. So the price sholud be taken according to column c. As i entered the quality name roamn in b2 it started to showing price in c3, while c3 is size column which i have to fill manually and after that price shoul be come in d3. As i write roman in b3, diwan set in c3 then price should be come 1198 in d3.
I like your response timing as you replied with in 1 hour of my post. Thanks for that. Please solve this.
But why it is require as Vlookup can easily give you desired result then why we need more calculation ? I saw many expert do the same...
Try
D3Formula:
Please Login or Register to view this content.
Thanks shukla.ankur ji. You are great. Can you please which course sould i done for making these kind of formulas. I am on job so i need them. Can you please advice and can you give me some kind of book etc. So that i can learn the logic of formulas.
Thanks again for solving my query too fast.
There is a lot study material available If you just google it. Yes you can learn a lot thing through this excel platform. I have learned many thing on this excel forum there are many excel Masters are available 24*7 if you require any help.
Thanks for feedback. Please add reputation by clicking star icon left corner on your screen on those post which helps you.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
like samba_ravi mentioned, it's to mask zero values. if a number is found, then great. VLOOKUP can retrieve that number. but if it's a blank, VLOOKUP gives you a zero.Originally Posted by shukla.ankur281190
say the number VLOOKUP retrieves is 100. 1/100 = 0.01
1/0.01 = 100
it gives you the same number
if the number VLOOKUP retrieves is 0. 0/100 = DIV Error
1/DIV Error = Div Error
DIV error will then return a blank
Ok I understood but what is necessities. I request you to please explain it well with some more example I will be very grateful .
self removal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks