I have a data sheet on one tab and I need to be able to put in information in
'A1' and in 'C1' I need what is beside that information in the data sheet.
So in the data sheet i can have 12 and then in the line beside it it sayes
54.2. I need the 54.2 to go in 'C1' on the other sheet. the data sheet has
about 1000 items in it.