I am attempting to create a form within excel where when a program/name is selected from a drop down list (developed from a larger table containing several lines of information for each program/name), cells to the right (in the same row) are automatically populated with information from the table for the specific program/name selected. The idea is to duplicate this so that two programs (out of the table of several) can be compared one to one. I've started a HLOOKUP formula, however it does not appear to be outputting the information
Solved by S. Q. in 17 mins