I'm trying to figure out a way to find a cell that includes a specific piece of information (the two are zip codes and dog breeds) and then pull the rate value that is the same row but the next column.
For example: I have two worksheets, the first is a calculator I'm building; the second has a column with zip codes (or dog breeds) and a second column that has a corresponding rate value (ex: 90001, 1.56). If I input the zip code of "90001" into the first worksheet, I want to pull the value that corresponds with that zip code from the other worksheet. So I want to pull the value of the B-column but search for the specific entry in the A-column. All of the values are unique, so there won't be any overlaps.
Bookmarks