Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting and auditing research tools and strategies

Authors: Thomas Weirich, Thomas Pearson, Natalie Tatiana

8th edition

9781118806487, 1118027078, 1118806484, 978-1118027073

More Books

Students also viewed these Accounting questions

Question

12.6 Analyze the emerging emphasis on employee recognition.

Answered: 1 week ago