MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 472|Reply: 2

how to get items' price?

[Copy link]

1

Topics

2

Posts

9

Integral

Newbie

Rank: 1

Integral
9
Post on 9-15-2016 21:25:10 | All posts |Read mode

I have a task to calculate the total sales amount, there are thousands of items, it's hardly for manual work.
Would you please help me to find a solution?

My questions please find attachment, I have to input all item's prices into the yellow cells, I wanna a easy way to do it.

Thanks.

@help

This post contains more resources..

You need to Login to download attachments. No account? Register Now

x
Reply

Props Report

0

Topics

632

Posts

1471

Integral

Super moderator

Rank: 8Rank: 8

Integral
1471
Post on 9-15-2016 21:29:02 | All posts
Sir, we just get your request,
You can use VLOOKUP, it's a easy way for you,
Formula VLOOKUP(A,B,C,default)
A: who you want to find
B: the area you have to go
C: exactly column number in the area which your target fall into
Default: normally 0

more information can be found in Excel helps.
Thanks.

This post contains more resources..

You need to Login to download attachments. No account? Register Now

x
Reply Support Opposition

Props Report

1

Topics

2

Posts

9

Integral

Newbie

Rank: 1

Integral
9
 Author| Post on 9-15-2016 21:29:32 | All posts
Thanks, my problem solved.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 2-22-2018 23:01 , Processed in 0.254304 second(s), 21 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!