Hello everyone. I have a complicated lookup that I need to do from 2 seperate workbooks. I will try to keep it simple. I am needing to place a value into cell C3 in “Workbook A”. In order to get that value, I need to take the part number, for simplicity call it “Part A”, found in cell A3 of “Workbook A”, search all of Column A in “Workbook B” until it finds the matching “Part A” and return the cooresponding value found in “Column F” of “Workbook B”. So if it did the lookup in “Workbook B” and found “Part A” to be in cell A567, I would need the value from F567 to be place into cell C3 in “Workbook A”. Basically I am trying to save myself alot of hunting for values, then pasting them from one workbook to another. I am not very experienced in doing lookups and any help would be greatly appreciated.