Jul 28 2022 05:10 PM
I would like assistance with giving a value to a number to be used in a database once selected for example:
row will have the numbers 1,2,3,4,5,6,7,8
and I would for those numbers to have a value for example 1=$3020, 2=$6040, etc. Due to this number reflecting a monthly dollar amount and subject to change I would like to also have one cell box where I can enter the numbers 1,2,3, and so forth but the value assigned will reflect overall. Please assist if you understand what I am implying. I tried the vlookup and not getting it to work. Thank you
Jul 28 2022 07:28 PM
Jul 29 2022 02:58 AM
I'd use a lookup table:
The formula in B2 is
=SUMPRODUCT(ISNUMBER(SEARCH(F2:F9,A2))*$G$2:$G$9)
Jul 31 2022 03:39 PM
Aug 01 2022 12:06 AM
Sorry, I don't understand. What do you want to do with the word Months in C4?