Software

Ask something
Discussion Locked

Cell Values

0 helpful
2 replies

by karabryan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a quote form and have a table on the form with column headings 1,2,3,4,5 and row titles of a,b,c,d. As the user selects a $ amount in the table, I need to populate the $ amount in another cell. Can someone start me in the right direction?

2 replies

by nz_justice

any cell with value $ = new cell Value, so when you create your new cell it is populated with the cell value selected by user. If you can access the code behind the code could be, newcell.value == $cell.value. If in spread sheet, cell selection (1-5,a-d) = new cell.

by sgt_shultz

excel?
try a VLOOKUP formula in the cell you want to 'populate'. you can pass the ROW and COLUMN of the current cell's to get it's value to the VLOOKUP formula.
just get vlookup working at first with a hard-coded cell number (or even more basic: a hard coded number). then embellish it with by feeding it a hard coded cell's content's value and then finally by passing the row and column numbers to get the value.
i suppose i am making gibberish out of it but am using these terms to give you clue into how the formula will work. you will end up 'nesting' your cell descriptors to get to the final value to pass to VLOOKUP (or HLOOKUP)
hih a little

This discussion is closed to new replies.