How do I use vlookup to match the meat and cooking method on both tabs (Main & Info) and then add text to the main tab under info from the Info tab by combing cooking Method and Delivery.
I know I can do CONCATENATE(C2, ". ", D2) in another column and then add it but I would like to skip this step
Maybe: =VLOOKUP(A2,Info!$A$2:$D$3,3,FALSE)&". "&VLOOKUP(A2,Info!$A$2:$D$3,4,FALSE)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Sorry but I noticed the columns didn't look right so i fixed them. But that's no big deal.
But I need to match the meat and cooking method since when I use your code you provided it gives me the same information if I added another row with the same meat name and different cooking method.
Try:
=LOOKUP(2,1/((Info!$A$2:$A$5=A2)*(Info!$B$2:$B$5=B2)),Info!$C$2:$C$3)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thanks for the help. I changed the code a little since I needed info and delivery status combined together as a sentence.
=CONCATENATE(LOOKUP(2,1/((Info!$A$2:$A$5=A2)*(Info!$B$2:$B$5=B2)),Info!$C$2:$C$3),". ",CONCATENATE(LOOKUP(2,1/((Info!$A$2:$A$5=A2)*(Info!$B$2:$B$5=B2)),Info!$D$2:$D$3)))
What if one of the columns is blank. How would I skip that column and add the text of the next column. if you take a look at Beef (BBQ). I just want to show up as Delivered Monday but my code shows it as
. Delivered Monday
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks