Vlookup

[jal0315]

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:

"FA138 Factory Caulk - SM5430 50gal drum"

<tbody>
</tbody><colgroup><col></colgroup>

 

[Jonmo1]

Try

=VLOOKUP('requisition page'!A2&"*",Data!A:B,2,FALSE)

 

[jal0315]

This worked perfectly. I was trying to mess with it some more before I looked this up and had something close to this.

Thanks!

 

[Jonmo1]

Glad to help, thaks for the feedback.