Hello and welcome to JustAnswer! My name is XXXXX XXXXX X 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.
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?
Yes, let me create a simplified version. Hold on.
Take your time
how do I attach a spreadsheet?
The easiest way is to use something like Wikisend: http://www.wikisend.com/
Just provide the URL or File ID when it is uploaded
Perfect. Just a sec
Ok, on C2 of Sheet 1, put the following: =VLOOKUP(B2, Sheet2!A2:B17, 2,FALSE)
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)
If you add to the LB table, you'll need to increase the range
No problem at all. Does that make sense?
Great. Just want to make sure you understand so you can do it yourself.
Is there anything else I can help you with?
Nope that did it. Thanks.