Hi Everyone,
May I ask for your help regarding with this matter. Im a newbie in excel formula. Im looking for the right formula to search and return the correct value. I tried Vlookup and IF conditions but I didnt get what i was tryign to look for.I think there is a better way to do this. Please help me.. I attached my file. Thank you very much.Serial.xlsx
Last edited by FDibbins; 05-08-2015 at 01:08 AM.
Put this on F9 and copied down as necessary:
=INDEX($B$3:$B$12,MATCH("*"&$E9,$B$3:$B$12,0))
or see the file attach, hope this helps
Maybe this>
=VLOOKUP("*"&E9,$B$3:$B$12,1,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you very much FDibbins and azumi. It worked perfectly as what I was planning to do. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks