LinkBack URL
About LinkBacks
Can someone please look at the formula in S4 and help me return the 2nd value? I'm lost on this one and running around in circles.
Thank you in advance for your help, you guys/gals are always an amazing help.
Thanks,
Tejay
Can someone please look at the formula in S4 and help me return the 2nd value? I'm lost on this one and running around in circles.
Thank you in advance for your help, you guys/gals are always an amazing help.
Thanks,
Tejay
Do you mean?
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Like that, however, if possible I would like to return the second value "1LB L Board (60%) Maple"?
Thanks again for your help..
Tejay
What determines that you want the second instead of the first?
Also will there ever be more than 2 "matches"?
The order which I have to Vlookups with the criteria. I dont believe it will ever have more than two results.
Thanks again.
I must be missing something. Is this what you want?
=IFERROR(""&VLOOKUP(B4,'Prod Line Info'!$A$1:$B$61,2,FALSE),"")
Pauley
My question is why that result you want as opposed to the result the formula originally gives. How do you tell the formula which result you want..so that you can copy the formula down and get the correct result for each row?Originally Posted by asburytl
Most of the items only have one available answer. For the select few that have two answers, what order of the Vlookup will place the required it in second place.
I'm up for suggestions.... basically I'm running into issues with my groupings. My original vlookup was based on the standard Yield, then I found out the some of the groups had the same standard yield value, which skewed the results.
Maybe you need to replace the VLOOKUPs with LOOKUP to find last matches?
e.g.
VLOOKUP(M4,'Prod Line Info'!$A$1:$B$61,2,FALSE)
would change to
LOOKUP(2,1/('Prod Line Info'!$A$1:$A$61=M4),'Prod Line Info'!$B$1:$B$61)
this looks for the last match, whether there is one match or multiple matches and returns the last of these and the corresponding value from column B.
Hello seandenniel,
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
I cant seem to get the right value I need with the new lookup formula, due to the different criteria on the product line tab. Any thoughts?
Thanks
This would be the formula in S4:
Please Login or Register to view this content.
This is only ever returning the 2nd value? I have highlighed some of the values that should be another value based on the criteria that I need. Any thoughts?
Thanks again for your time,
Tejay
That is the question I have been asking? What are those criteria? How am I (or Excel) supposed to know if you want the first or second or none or whatever?
hii i have a problem please some body help me out:
I have datas in 2 sheets:
sheet 1 sheet 2
Name number Name number
a 1235 a 1235
b 5689 b 5689
c 9876 c 9876
d 9876 d 9879
e 8796 e 8796
the names and numbers are same in both the sheets except name d is entered wrongly in sheet 2(9879).my question is how can i use v lookup to determine that the name d in sheet 2 has been entered wrongly, suppose its a huge sheet with many names and numbers so its impossible to track with ***** eye.please somebody help me out
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks