Conditional Formulas - How do I make quantity of a cell change the value of other cells?

Untitled.jpg

Hi,

I'm really new to this spreadsheet stuff and I can't seem to find a simple answer to this question...

How do I make a cell change to another cell's value based on the value of a third cell?

That's a confusing way to ask, perhaps. In my example you can see I have quantities (1-12) and different dollar amounts for each. So, if i were to enter '3' as a quantity in column A, I would want column B to display $3 and so on.

Any help would be greatly appreciated.

THANKS!

Hi

have a look at the VLOOKUP function. This will bring back the results you are looking for based on the example picture.

rylo

I will try that, Thank you!

Hi

Set up and example file (not a picture) that is representative of your real situation and we will have a look.

rylo

VLOOKUP doesn't require the values to be in column one, but it can only return results to the right of whatever it is looking up.

If you get us an example sheet (as ryo recommended), then hopefully we can help.

I have one ready. How do I post a excel file?

Hi

In the replies area, select go advanced, then scroll down to manage attachments. Work through the screens and attach the example file. Don't attach your real file, just a relevant example one. If that is too large, then zip it first.

rylo

EXAMPLE.xlsxEXAMPLE.xlsx

Here it is, I think...

Thanks for taking this time to help me

Hi

Q11: =IFERROR(VLOOKUP(P11,P$26:Q$37,2,FALSE),"")
Copy down to Q15, then copy Q11:Q15 and put into S11, U11 etc

Is that what you want?

rylo

Exactly the formula I was looking for! Thanks for all your help! And for not making me feel like the idiot I am when it comes to Excel. You're the best!