Here's what I want to do.
Sheet A has a list of numbers between 1-99. These are listed in column A.
Sheet B is a "database" where all numbers, 1-99, are listed in order in column A. Next to those numbers in column B are dollar values. 1 is next to $500, 2 is next to $750, and so forth.
I want column B of sheet A to search the "database" and match up with the corresponding dollar amount.
I know this may sound basic and I've dealt with way more complicated things in excel but I'm honestly a bit stumped and can't find the answer I want.
Any help is appreciated.
Bookmarks