Hi,
I need help doing a Vlookup for fill a description.
Need the Vlookup to check the Part number in A2 and match it to a description on another sheet. The description also has the part number in there and I figured I could use a =left(B2,5) statement to help with the Vlookup.
Second sheet where description data is being pulled from is simply called data. So is in column A2 on the requisition page is saying "FA138" I need to pull the description from the Data page.
Description would read something like this: [TABLE="width: 459"]
<tbody>[TR]
[TD]"FA138 Factory Caulk - SM5430 50gal drum"[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
I need help doing a Vlookup for fill a description.
Need the Vlookup to check the Part number in A2 and match it to a description on another sheet. The description also has the part number in there and I figured I could use a =left(B2,5) statement to help with the Vlookup.
Second sheet where description data is being pulled from is simply called data. So is in column A2 on the requisition page is saying "FA138" I need to pull the description from the Data page.
Description would read something like this: [TABLE="width: 459"]
<tbody>[TR]
[TD]"FA138 Factory Caulk - SM5430 50gal drum"[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]