Hi,
I can find the results according to three variables with using IF (eğer) and VLOOKUP (düşeyara) formula. But l will use this formula 1500 difference cells, therefore can be shortened with macro?
Formula:
Macros can be shortened with the following?
Please Login or Register to view this content.
=value(target;A;B;C) as.
I've added a sample file.
Thanks.
Regards.
This looks a index / match question to me.
See the attached file.
please reply.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks oeldere.
İf "name" value is another value other than DH1,DH2,DH3,DH4 and DH5, result should be 0. But indis formula fails as "#NO".
See the attached file with the amended formula.
if you use excel 2007 you can use the formula iferror()
Thank you,
Formula is working. But The formula was long again. a little shorter.
First:
Second:Please Login or Register to view this content.
Please Login or Register to view this content.
Maybe you can translate your formula into englisch.
You can read turkish, I can't.
Or post your solution as an excel file, so excel will translate it for is in our own language.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks