I have a workbook with 3 pages. One is a form, one is a job list, and the
last one is a vendor list. On the form, I have two cells I fill with vendor #
& job # information, which I want to fill in below in other cells of the
form. I can get one of the vlookup formulas to work, the other one comes back
with either the wrong job location or #N/A. My formula looks like this:
=VLOOKUP(L1,'Job List'!$A$1:$AY$9999,2,FALSE).
My job list and vendor lists are simply two columns each; identifying number
in column A, and Vendor name/Job location in Column B. Help?
Bookmarks