Column A = Vendor part # for item based on data in column B.
Column B = Results of Vendor a "Data Validation LIST" on another worksheet that I choose from.
Column C = Pricing Lookup from additional vendor workbooks
Column D = Part #'s of multiple rows of inventory items that I have assigned my part #'s to.
Columns E - L = Data for Column A
I'm trying to fill in Column A using the correct Column of information based on the a variable value of Column B.
=VLOOKUP(D2,D1:L11,2,FALSE) <<<<< Need to replace the 2 for the column with a variable based on Column B was attempting INDIRECT with no luck.
[Blocked Image: http://www.ozgrid.com/forum/attachment.php?attachmentid=55620&stc=1]