Finding a number by searching the last value
Hello everbody, i am the new one in the forum
I have a problem in my excel, it can be easy for you
ı attached my excel to the post
There are 2 sheets, 2 sheets are the same except "referance no" column belongs to sheet 2
i would like to find the latest "Job B's referance number" for sheet 1 by checking box quantity (must be equal) in Job B's info in sheet 2.
i hope i could explain my problem
Last edited by shtmd; 03-26-2018 at 04:08 AM.
No file attached.
Attach a sample workbook (not image).
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Thanks, i could attach the excel file with your help
Attachments are not valid and screenshots are not very useful.
Attach a small sample file as per instructions in post #2
Try
B9Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
The attachment works fine, but tells us nothing new.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
it says
#DIV/0!
No, it doesn't. It works perfectly. Just copy and paste the formula into B9 on sheet 1.
excel forum.JPGOriginally Posted by AliGW
it says like that
Replace , with ; as per your region
That's not a #DIV/0! error!!!
Change commas to semi-colons for your locale:
=LOOKUP(2;1/(Sheet2!$A$2:$A$9=$A9);Sheet2!$B$2:$B$9)
you are awesome guys thank you very much, it must be the fastest forum on the web
Happy to help you
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Last edited by shukla.ankur281190; 03-26-2018 at 04:12 AM.
i did
Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks