• This topic has 2 replies, 1 voice, and was last updated 8 months, 2 weeks ago by anonymous.
Author
Topic
#2477173

i am looking to make a task auto

hopefully you can make sence of the idea below

column A has a list of names, say 200

Column b is a total amount

Column C i add a name from the list of column A

Column d has a price i insert

how do i make column B look at  column C find the name in column A and add the price from column D to Column B

cheers

dave

Author
Replies
• #2477426

VLOOKUP or MATCH is usually the way we do this.
The data source is in A and the value to lookup is in C.

If you need more help, post some sample data from your sheet for us to work with.

cheers, Paul

###### 1 user thanked author for this post. Kirsty
• #2479688

For what you’ve described, you don’t need a VLOOKUP or MATCH function; all you need is something as simple as:

=IF(\$C\$1=A2,\$D\$1,0)+100

where A2:An holds the names, C1 is the cell holding the name to match, D1 holds the amount to add and 100 is the base amount. Simply copy the formula down as far as needed.

If you need to have different base amounts in column B, you’d do best to put those in B2:Bn and use a formula like:

=IF(\$C\$1=A2,\$D\$1,0)+B2

in, say, E2 and copied down as far as needed.

Something more complex would only be needed if you might have multiple names and amounts in columns C & D, respectively. Even then, a simpler formula could be used if the additional amounts were added to the same rows as the listed names – you wouldn’t even need the IF test.

Do note that any formula-based approach will be volatile – change a name of amount and your calculated amounts will change.