Dropdowns and lookup function

[underdog387]

I currently have a spreadsheet that I am using 2 dropdowns with the Lookup function to pull information from 2 other sheets in the workbook. the first item in the dropdown and the 18th and beyond items in both dropdowns work correctly, however items 2-17 pull the wrong information. I am using another spreadsheet that uses the same format as I am using, anf it works properly.

 

[WarPigl3t]

Usee google to search for "absolute references in excel" and modify the formula you used as an absolute reference

If that doesn't work then post your formula in the thread.

 

[underdog387]

Usee google to search for "absolute references in excel" and modify the formula you used as an absolute reference

If that doesn't work then post your formula in the thread.

This would help if I were using the same result in each cell.
Here is my spreadsheet: https://www.dropbox.com/s/boa0ygewrqandgj/Excel Help.JPG?dl=0
The ones below work the same way. They are simply referring to another page.

 

[underdog387]

I figured out my problem. Thanks for the attempted help.

 

[Tyron]

Hey underdog387,

So what was the problem and how did you solve it?

later

Ty

 

[underdog387]

If you look at the picture, there are 7 fields that pull information from the other sheets based on what what was picked in the dropdown. Each dropdown was reading from a different page. I put them all on one page so I could see what was happening. As you can see from this newer picture, I had to have a column with what was showing in the dropdowns and also add one that had the same info in it, but the rest had to be in "alphabetical/numerical" order for Excel to read it properly. Once I did that, everything was reading correctly and don't have any errors now. https://www.dropbox.com/s/nqrqhmkfnhomxr4/Excel Help2.JPG?dl=0
If that didn't make sense, lemme know and I'll try breaking down what didn't make sense.