I have 1 workbook where I am trying to validate and populate two sets of data. Idealy when the user fills in 1 column, I have the other column autopopulate based on a list from a second tab. This is working great for the first set of data, but when I use the similar formula for the second set of data, the vlookups aren't matching up correctly.
In my attached spreadsheet, the user fills in column C from the dropdown selection then Column B autopopulates based on column C. This one is working perfectly. I am trying to do the same thing for columns E and D using a different set of lookup data. The lookup data for both scenarios is located on the second tab.
If I am basically using the same formula with the exception of the data set, I do not understand why one is working and the other not. Am I missing something in my second set of data?
