take the value of the goods + add up to the price
Hi , everyone
I'm trying to create a script to find the value of an item, but I'm having trouble,.
1. If I look for an item that is not on the list, the value should appear "0" but instead another value should appear
2. I also want after the value of the item appears it will be added up with the price of the item (I tried to search on Google and didn't find it, maybe I had the wrong keyword)
https://www.ozgrid.com/forum/index.p...e/#post1239520
Last edited by DianChris; 09-14-2020 at 04:08 AM.
Hi Chis
pls try VLOOKUP() function.
prashanthaw
can you give a sample script for vlookup or keywords for google search ( I will try to develop + learn )
sorry because I am new to VBA
and the script that I applied the results from google
Hi Chris
this is not VBA. just general Excel function
I have attached a sample. pls try it and d'ont hesitate if any help need further
prashanthaw
formula that you function
but
What if I take the value of the item with a distance?
I once tried the vlookup formula which took a long process because the data I used reached hundreds of thousands or more
sometimes on 1 worksheet use several different formulas
so I tried VBA
[Prashantha] - No matter you can get any amount of data from other worksheet or workbook.Originally Posted by DianChris
prashanthaw
formula that you function
but
What if I take the value of the item with a distance?
I once tried the vlookup formula which took a long process because the data I used reached hundreds of thousands or more
sometimes on 1 worksheet use several different formulas
so I tried VBA
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Rory
Re: take the value of the goods + add up to the price
rorya
forgive me me
I also post this problem on another web
How do I provide cross posting links?
I will read the rules again
Copy and paste the web address from the other site(s) into a post in this thread (preferably the first post if you can still edit that one).
rorya
I have updated the link in the first post
and I ask to close posted there
You don't need to close it, you just needed to add the links (both here and there).
rorya
I have given the link there too
but I already said closed
if it is solved here or there will be me
update and the message
Someone, can anyone help my problem
maybe a keyword or something ,..
Re: take the value of the goods + add up to the price
Hello everyone,
Please Login or Register to view this content.
I did add script but it's still stuck with the result of "Tas" is still wrong and it should be 5000
is there anyone can help me
Last edited by DianChris; 09-16-2020 at 04:22 AM.
Hello ,
the problem I asked earlier has been found and is running normally, but there is a little problem when;
1. Enter the year in column "C1" the result of "Tas" comes out first, Column "C1 & C2" should be filled in then new results appear
where is the lack of my script?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks