How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Brandon M. Your Own Question
Brandon M.
Brandon M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6977
Experience:  10+ Years Mac Support as contractor and currently an System Administrator for law firm
12024030
Type Your Microsoft Office Question Here...
Brandon M. is online now
A new question is answered every 9 seconds

I have a 2 columns. One with a LB value (column A), one with

This answer was rated:

I have a 2 columns. One with a LB value (column A), one with a $ value (column B) that corresponds with the LB value in the same row. In a different worksheet, I have rows with item. If I put the weight of an item (eg, 4lbs) into a cell, how do I get the $ value in another cell to autofill with the corresponding Column B value in the original worksheet?

Brandon M. :

Hello and welcome to JustAnswer! My name is XXXXX XXXXX I would be glad to assist you with your issue today. Please note that I am in eastern time (UTC -5:00) and am generally online between the hours of 10 AM and 4 PM and some evenings between 7 PM and 11 PM.

Brandon M. :

This can be accomplished with a VLOOKUP function. Would you be willing to send the spreadsheet over and I can set up an example for you?

Customer:

Yes, let me create a simplified version. Hold on.

Brandon M. :

Take your time

Customer:

how do I attach a spreadsheet?

Brandon M. :

The easiest way is to use something like Wikisend: http://www.wikisend.com/

Brandon M. :

Just provide the URL or File ID when it is uploaded

Customer:

http://wikisend.com/download/992878/example.xlsx

Brandon M. :

Perfect. Just a sec

Brandon M. :

Ok, on C2 of Sheet 1, put the following: =VLOOKUP(B2, Sheet2!A2:B17, 2,FALSE)

Brandon M. :

A VLOOKUP will use the table specified ("Sheet2!A2:B17") and look for the value (B2). It will return the second column (2, the dollar amount) and the match has to be exact (False)

Brandon M. :

If you add to the LB table, you'll need to increase the range

Customer:

excellent. thanks.

Brandon M. :

No problem at all. Does that make sense?

Customer:

perfectly.

Brandon M. :

Great. Just want to make sure you understand so you can do it yourself.

Brandon M. :

Is there anything else I can help you with?

Customer:

Nope that did it. Thanks.

Brandon M. and 3 other Microsoft Office Specialists are ready to help you