Spent days with this one

Originally Posted by skyeler

I have gotten stuck and could really use your help. What I am trying to do is Lets say on Sheet1 I have an Item numbers in columnC, a description in columnE, and a cost in columnI. Is there a way to goto sheet2 and in cell A1 type my Item number and it automatically fill in columns B and C with my description and cost from sheet1?

Thanks for your help
Skyeler

You need the VLookup

in cell A1 in Sheet2 the number is typed, in cell (say) B1 put

=VLookup(A1,Sheet1!A:B,2,False)

this will bring column B for the number

in cell C1 type

=VLookup(A1,Sheet1!A:C,3,False)

to get cell C from the same row.

hth
---