Question
EXCEL Expert Needed , if you are clueless ( like I am ) Do NOT post Fake , incomplete, or incrrect answer. Please step by
EXCEL Expert Needed , if you are clueless ( like I am ) Do NOT post Fake , incomplete, or incrrect answer.
Please step by step instruction of how to do this, ( including the screen shot of your excel sheet) , I should be able to replicate it on my end, with no problem/s
here it goes
I have
Rent value ( $200) in cell I5
Supplies ($200) in cell I6
Food( $500) in cell I7
now I want to cpoy paste the individual prices in Cell E3 but instead of putting the values or cell number into the E3 cell I want to type "Rent" in E3 and $100 should pop up in E3.
Note: I have a list of 100 items( Rent , supplies and food are only 3 of them) and I want to type their names and get the values , instead of finding their values or copy and paste each.
Book1 Microsoft Excel File Home Insert Page Layout Formulas Data Review View as Cut Calibri Wrap Text General Paste E,- Merge & Center $% y Format Painter Blu - Clipboard Font Alignment Number 10 2 Individual price equal to Rent or Supplies or Food 4 Rent Supplies $200 Food $100 10
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started