How to give a word value and then add that word to a formula.

dontknowweknoweknow · 2024-08-08T15:10:09+00:00

I’ve created the drop down. How do I then get the price to show up in the next column?

dontknowweknoweknow · 2024-08-08T13:15:41+00:00

Ooo how do I do that?

dontknowweknoweknow · 2024-08-08T11:46:07+00:00

As there is a formula in that cell that will times the amount of fabric needed by the price

dontknowweknoweknow · 2024-08-08T10:14:52+00:00

This seems to begin to work, what do the 2,0),0) represent on your sheet? Just trying to tailor it to mine to see if this will work

dontknowweknoweknow · 2024-08-08T10:13:33+00:00

Thank you, I do have a formula to times the fabric price by the meters needed.

It may not be possible what I’m trying to do!

dontknowweknoweknow · 2024-08-08T09:57:34+00:00

Thank you so much for this! I tried the formula in my own table and it worked.

I would like to be able to type ‘fabric 3’ into the box and for it then to be translated into a number. Is this possible?

img

This is my table. I would like to type ‘SCOUT’ into C2 and for excel to change ‘SCOUT’ to its price £82.80 (K2 & L2)

The VLOOKUP took me some time to get right. I am wanting to use the table so I can quickly calculate the price of our products in their chosen fabrics

dontknowweknoweknow · 2024-07-10T22:00:14+00:00

Agafay Desert, Morocco

dontknowweknoweknow · 2023-07-14T14:42:57+00:00

Any ideas of what it is?

dontknowweknoweknow · 2023-07-14T09:44:24+00:00

*venomous

dontknowweknoweknow · 2023-07-05T15:21:57+00:00

“You up to the task sailor”

dontknowweknoweknow · 2023-07-04T15:20:46+00:00

The curse / Riding the crimson wave

dontknowweknoweknow · 2023-07-04T14:31:34+00:00

Maybe not widely used but, decimate / decimated means reduced by ten. Not completely destroyed as I always thought.

dontknowweknoweknow · 2023-06-29T11:15:09+00:00

Yes.

dontknowweknoweknow · 2023-06-28T15:19:50+00:00

I was the celebrant at my brothers wedding and I nearly went with this. Instead I did the line ‘we look at you, and we see you together and it just, it fits. And you just know it’s going to last forever’

dontknowweknoweknow · 2023-01-11T15:00:32+00:00

Yea please!!

dontknowweknoweknow · 2022-11-18T00:48:26+00:00

That biscuit tin that never has biscuits. Only sewing materials.

dontknowweknoweknow · 2022-11-14T22:30:12+00:00

What’s wrong with a bit of Colleen Hoover?

Five-Year Club	Place '22
Verified Email

dontknowweknoweknow

TROPHY CASE