Hello,

I have a log where I need to populate a 'Folder' field (column F starting at F6) that I want to populate with data from a list (Folder) based on values entered from a list (Document Type) in Column H (Document Type) starting at H6.
Example - if I enter Specification in the Document Type field in column H, then it would return Customer\Specification\ in the Folder field in column E

The lists are below:

Document Type
Model File
ISO
Specification
Purchase Order
Line Class
Orthographic
Structural Detail
Vendor Cut Sheets
Procedure
Other

Folder
Customer\Specifications\
Customer\Drawings\IFC Drawings\
Customer\Specifications\
Customer\Specifications\
Customer\Specifications\
Customer\Specifications\
Customer\Drawings\
Customer\Drawings\Vendor Drawings
Customer Orders\QA-QC (QCS)\
Customer\Specifications\

I tried a Vlookup but it returns a value of 0 in every row (=VLOOKUP(F6&"",B124:C134,2,0))

I'm hesitant to upload as there is proprietary information, so if a sample is needed I can try to create a redacted workbook.