In cell s2, I need to lookup two different columns based on the "product line info" criteria, for example in cell s30, how do I only return the "Bacon Slice- Retail" value only?
Any help is greatly appreciated....
Thanks
In cell s2, I need to lookup two different columns based on the "product line info" criteria, for example in cell s30, how do I only return the "Bacon Slice- Retail" value only?
Any help is greatly appreciated....
Thanks
Last edited by asburytl; 09-07-2011 at 10:33 PM.
in s2 try
=IFERROR(""&VLOOKUP(B2,'Prod Line Info'!$A$1:$B$60,2,FALSE),""&VLOOKUP(M2,'Prod Line Info'!$A$1:$B$60,2,FALSE))
and copy down
or
=IFERROR(IFERROR(""&VLOOKUP(B2,'Prod Line Info'!$A$1:$B$60,2,FALSE),""&VLOOKUP(M2,'Prod Line Info'!$A$1:$B$60,2,FALSE)),"")
Last edited by Azam Ali; 09-07-2011 at 12:16 AM.
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks