Formula Assistance--Not sure how to do this

[KelleyAnn1018]

This is probably very elementary, but I cannot find the answer anywhere online or it is not relevant to my issue. I need formulas that are essentially the same except for the data to return. All the needed data is 1) on a different worksheet within the same workbook, and 2) dependent upon the data in Column D. I need the formulas to return 1) "Weight (Each)" -- Column K, and 2) "Shipping included in price (per unit)" -- Column L. Thus, for Line 2, Column K should pull "1" and Column L should pull "$2.60". Rather than writing a "IF(D2=xxx" formula hundreds of times (I have almost a thousand different Items), how do I write this--again, sorry if this is elementary. I'm not new to Excel but this one has me stumped! Here is the spreadsheet (customer information has been blanked out for confidentiality purposes), and the worksheet with the needed data (Column A for item, Column B for weight, Column C for shipping cost). Thank you in advance! Have a great day!

[etaf]

assuming the table is in sheet2 columns A,b & C

to pull back the number from column B

IN K

index(sheet2!$B:$B, match(sheet1!$D2,sheet2!$A:$A,0))

to pull back the number from column C

IN L

index(sheet2!$C:$C, match(sheet1!$D2,sheet2!$A:$A,0))

easier if you attach a sample spreadsheet

[KelleyAnn1018]

Hi Wayne, and THANK YOU!

I tried this approach and nothing happened, I know I am doing something wrong. I've attached a workable sample worksheet for reference.

Thanks for your time, it is much appreciated!!!!!

[Yoandsm]

Hey KelleyAnn1018

Let me know if this works for you. I had to add a formula to Sheet2 which is what my vlookup is based off of on Sheet1. I also tested this with some of the more complicated identifiers that you have towards the bottom of Sheet2 in (Now) Column B.

It seems to work fine with those. I can't guarantee that it will work with some of those more complicated ones, but I know it works for the ones starting with "AK-" and a few of the others. Let me know if this gets you started at least. I'm happy to try to tweak this if it's not handling all of them.

Thanks!

[KelleyAnn1018]

Thank you thank you thank you this works!!!!

[jeffreybrown]

Hi KelleyAnn1018,

Glad you have found your solution, but please follow out forum rules next time about thread titles.

Administrative Note:

Welcome to the forum.

We would love to help you with your query; however, the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly.

To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)