Search Formula Or Code?

[rockyw]

I have a spread sheet I add to each week. Column A has item numbers, columns B and C have information for each item. Is there a way to search for a known number in column A and have the sheet go to that row, or put that data in a differant column and row of my choice? Maybe the item number I'm looking for in row 2, columns D,E and F? Thanks

 

[Excelestial]

Absolutely. You'll want to use the functions VLOOKUP, HLOOKUP, INDEX & MATCH, or even OFFSET or SUMPRODUCT.

 

[rockyw]

If I want my search cell D2, I put my formula in there, it finds the item number and returns the item numbers data from the same row in cell B and C and returns that in E, F 2? Please give me a start and I will experement with any changes. Thanks

 

[jasonb75]

=Vlookup(D2,$A$2:$B$20,2,0)

entered in E2 will look for the content of D2 in A2:A20 and return the corresponding entry from column B

Likewise, =Vlookup(D2,$A$2:$C$20,3,0)

Will return the corresponding entry from column C

 

[rockyw]

jasonb75 Thank you very much. I need about 200 rows right now, I changed the formule to 1000 so it will be good for a while. Thanks for the help, makes my life easier. Rocky