Software

Ask something
Question Locked

excel automatic data retrieval

0 helpful
3 replies

by simon.c.l

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi. I'm a newbie I'm afraid and this is probably really basic stuff for you guys. I simply want to input a number in a cell which corresponds to a number in a list on another worksheet. I want excel to fill in the rest of the row from that list for me. For example if the list is column A product ref, B product, and C product price, i would like excel to fill in the row if i only fill in column A.
Hope someone can help

3 replies

by cale

There is a function in excel called HLOOKUP that can do what you want, the first parameter one is the value that you want to lookup, aka item number; parameter two is the array of information you want to lookup that data from; parameter three is the column or row of the index containing information, aka item numbers on a price list.

http://office.microsoft.com/en-us/excel/HP052093351033.aspx

That link should help explain it better.

Good luck!!

by simon.c.l

Brill. Really appreciate the help. Just got to put it into practice now.

This discussion is closed to new replies.