Hi I am really stuck on this problem can anyone help?
I have a spreadsheet with a column (D) of words. If the word in cell D3 equals say 'Fuel' I want to post a number in column A3 = "7300"
I have worked out a formula to pick up the word fuel and post it as a number but i then need to have that formula running down the whole of my column A, and would need to amend each line to change the formula. Ideally i would like the formula out of the way on the page so that I can amend it as appropriate. eg
initally I want to search for 'fuel' and put in the number '7300' into column A (on the same line) BUT then i want to be able to change the formula to look for say 'Cash' and put the number '1230' in the column A on the same line as the word 'CASH'
7300 fuel
1230 cash
7504 personal
7300 fuel
7509 purchases
Is this possible????
Thanks
Tracie
I have a spreadsheet with a column (D) of words. If the word in cell D3 equals say 'Fuel' I want to post a number in column A3 = "7300"
I have worked out a formula to pick up the word fuel and post it as a number but i then need to have that formula running down the whole of my column A, and would need to amend each line to change the formula. Ideally i would like the formula out of the way on the page so that I can amend it as appropriate. eg
initally I want to search for 'fuel' and put in the number '7300' into column A (on the same line) BUT then i want to be able to change the formula to look for say 'Cash' and put the number '1230' in the column A on the same line as the word 'CASH'
7300 fuel
1230 cash
7504 personal
7300 fuel
7509 purchases
Is this possible????
Thanks
Tracie