Hello.
What formula would I use to populate Column H (Price) with a value option, by changing Column F (Replied) and depending on the age group selected in Column G?
I have looked at "IF" "AND" and I am trying to understand if i can use "INDIRECT" but honestly don't know how so I am turning to you guys to ask for help?
MacBook Pro (Retina, 13-inch,Early 2015), macOS High Sierra (10.13.1)
I would no use a pop-up in column H. I would have that fill in automatically based on the selections in columns F and G.
Add a second table for the price list and name the table "PriceList" and set up as shown. The first row is a header row
In the guest list table (on the left)...
H2=IF(F2="YES", VLOOKUP(G2,PriceList::A:B,2,FALSE), "")
this is shorthand for... select cell H2, then type (or copy and paste from here) the formula:
=IF(F2="YES", VLOOKUP(G2,PriceList::A:B,2,FALSE), "")
to fill down, select cell H2, copy
select cells H2 thru the end of column H, paste
There are no replies.
Guest list Calculator formula
