Multiple IF Statement? Or Lookup?

[DJReda]

Hello,

I’m working with a construction punch list on excel. One worksheet contains a column with descriptions of work items. These work items may only appear once in the column, or may appear on several lines in the same column. (I’m going to refer to this worksheet as worksheet “A”)

On another tab within the same workbook, I have done an advanced filter so I can have only the unique items in this new list. (Let’s call this worksheet “B” So basically, on worksheet “A”, I have all the items (about 8000) and worksheet “B” I have about 1400 unique items.

My goal is to assign dollar values to every item in worksheet A in a column next to the descriptions of work. Instead of making 8000 entries (with the chance of needing the update the values) I want to assign values to the unique items on worksheet “B” and have worksheet “A” check worksheet “B” for a matching description and then use the value next to the description of worksheet “B”.

I guess this would be similar to having an IF statement with a huge amount of variables but I know this would not work. Any suggestions would be GREATLY appreciated! I've also attached a graphical example in case it helps to explain this question.

Thanks in advance!
Dominick

[NBVC]

Vlookup should do it...

e.g. =Vlookup(A2,Sheet2!A:B,2,FALSE)

where A2 is your item in the Sheet A and Sheet2 is the name of Sheet B where A:B are the columns that contain the table.

[DJReda]

NBVC,

Thank you!
It worked like a charm and will save me HOURS of work. Your help is truly appreciated!!!

Dominick

Vlookup should do it...

e.g. =Vlookup(A2,Sheet2!A:B,2,FALSE)

where A2 is your item in the Sheet A and Sheet2 is the name of Sheet B where A:B are the columns that contain the table.