I've been working with Excel for four years or so now and have a pretty good knowledge of all the basic functions. I'm currently working with a big list of products, four columns of data and about 200 rows. A colleague has asked me to put together a spreadsheet capable of seaching the list of products for a code (that's been entered by the user), and then displaying the other information about the product (Two text fields and one numeric). I've previously accomplished this through use of nested if statements, although the previous sheet only had about 80 rows of information and took ages to put together.
Is there a method of linking, searching and displaying information that I'm not aware of? My inital plan was to use a nested IF statement to check the entered data against the product codes to see if there's a match, but after seeing the amount of data I'm working with it just doesn't seem feasible. And then of course, I have to link the found code with it's information and display it all. I'd be very grateful for any input on this, it's driving me nuts!
Is there a method of linking, searching and displaying information that I'm not aware of? My inital plan was to use a nested IF statement to check the entered data against the product codes to see if there's a match, but after seeing the amount of data I'm working with it just doesn't seem feasible. And then of course, I have to link the found code with it's information and display it all. I'd be very grateful for any input on this, it's driving me nuts!