I have some info on a spreadsheet with numbers and I want another sheet so that I can lookup a number from one sheet and when I type that specific number and enter another number in another column I want for it to add them together. How would I do that?
This is hard to explain, but if I have 548 which equals 64.110 miles then on another sheet I type in 548 so it gives me 64.110 but in another column next to the 548 i typed in I also type in 0.321 so the return in another column would add the 64.110 and the 0.321