I'm not sure if my picture is showing on this thread....
Column A has no formula
B6 has a left formula taking the first 7 characters of cell A6
C6 has a formula that takes the information in B6 and VLookups an ISN Grade on a different Excel Workbook e.g. A,B,C,F
=IFERROR(VLOOKUP(B6,'ISNGradeReport'!$C$1:$D$65536,2,FALSE),"NA")
My issue is if the ISN Grade Workbook has multiple account numbers in the cell. Can I add an embedded search formula in the VLookup?
Thank you!
excel forum.JPG
VLookup only finds the first found value.
That is the way VLookup works.
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.
Is there another parameter which will distinguish between same a/c numbers?
Unfortunately there is not. Just the account number, and sometimes there's more than one in the cell.
What do you mean by this? "My issue is if the ISN Grade Workbook has multiple account numbers in the cell. " can you illustrate, preferably by posting an Excel sheet?
Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
iI the hope something can be done can you post a sample of your data and expected results?
I can't seem to add the xlsx.................
I emailed it directly to the person who PM'd me. I still can't add the attachment for some reason. It's clocks out.
Last edited by calliebrin; 06-18-2015 at 11:23 AM. Reason: Added Text
To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
It helps if I use Chrome........ I've attached the workbook
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks