Hi Excel gurus,
I am looking for a function that when the item description(C2) in the LinenData sheet matches the item description (B2:B36) in LookupList sheet, then will reference the Weight data off of the LookupList sheet and multiply it by the Qty on the LinenData sheet giving H2 on the LinenData or in others wards 250 * .221000 = 52.25lbs.
I am not good with the match, index or lookup functions. I was thinking someone would have an answer for me. Thanks in advance for the help.
LeapingLizardhelp1.xls
Bookmarks