VLOOKUP Question

[Bob Vance]

--
Is it possible to bring a formula in on a VLOOKUP, like copy 10 cells above
or times the cell to the left by 5?


Thanks in advance.........Bob Vance

 

[Frank Kabel]

Hi Bob
not really sure what you're trying to do. you may give an
example?

 

[Bob Vance]

I have a drop down list and want the cell to the right which is a VLOOKUP to
the list so it will carry the formula over like add the 10 cells above or
can it only bring over a value? Really I need to bring over a .offset on a
VLOOKUP is that possible?

 

[Frank Kabel]

Hi Bob
still not really an example
What do you mean with Offset?. A formula can always return
only a value (and can't fill other cells)

 

[Bob Vance]

If I have a drop down list , and I have a name define with a VLOOKUP,
=IF(ISNA(VLOOKUP(AU169,ZLINE3_CHARGES,7,0)),"",VLOOKUP(AU169,ZLINE3_CHARGES,
7,0))
Can the 7th cell from my define which the above formula relates to have
something like "sum of 10 cells above"
so as it would add the 10 cells above after I selected it from my drop down
list. hope this is not to confusing
TIA Bob

 

[Bob Vance]

SUB - TOTAL $1,185.00
+ GST 12.5% $148.13
TOTAL $1,333.13

Or if GST 12.5% was a drop down list and 148.13 was a formula from VLOOKUP
that times by 0.125 , Then maybe I select my drop down list and go to GST
10% then my VLOOKUP with its formula *0.10 would give me a total of $118.50
TIA Bob

 

[Frank Kabel]

Hi bob
after multiple readings of your last two post I'm
confused
Probably not enough coffee/sleep on my side.

If you provide an example try the following:
- state the cell reference for your example
- state exactly what you want to multiply, etc.

for example what do you mean 'have a name define with
VLOOKUP)...

 

[Bob Vance]

At the Moment when I click on my drop down list I have a cell next to it
which adds a value which has been written as the formula below, What I want
is not a value but a formula that adds some cells above or even a formula
the times the cell above by 12.5 %, but remembering that each of my sixty
invoices have this drop down list so the formulas cant be relevant to
specific cells but only to the cell above or copy 10 cells above so as I get
the sum
Sorry if this is confusing TIA Bob

 

[Frank Kabel]

Hi bob
sorry I don't get it. Do you want to sum the cells from
the lookup location. If yes a combination of OFFSET and
MATCH may do.

If you like email me your file (show in the file the
expected result) and I'll have a look at it
email: frank[dot]kabel[at]mummert[dot]de