gcapp
05-15-2013, 09:39 AM
I'm hoping that someone can help...
I have a spreadsheet with specific values in column A that should correspond with values in column B. So if there is a value in Column A (say 1), then the value in column B should be a certain value (say $100)
Example:
Column A Column B Column C Column D
1 $100 type in 2 how to get $500 to appear
2 $500
3 $1000
What I am looking for is if someone types in the value that exists in column A (say they type in the number 2 in column C) then the value that corresponds in column B ($500 in this case) will automatically appear in column D?
Hope this makes sense. Any input would really be appreciated.
I have a spreadsheet with specific values in column A that should correspond with values in column B. So if there is a value in Column A (say 1), then the value in column B should be a certain value (say $100)
Example:
Column A Column B Column C Column D
1 $100 type in 2 how to get $500 to appear
2 $500
3 $1000
What I am looking for is if someone types in the value that exists in column A (say they type in the number 2 in column C) then the value that corresponds in column B ($500 in this case) will automatically appear in column D?
Hope this makes sense. Any input would really be appreciated.