The following formula looks for the last instance of an entry containg the letter "A" in a small range or return "NoData" (supplied by daddylonglegs of this site)
How can I adapt the formula to select the last entry in the range containing the letter "A" OR "vc" and if neither return "NoData"
Any help appreciated
Rgds Nigel
=IFERROR(LOOKUP(2,1/(LEFT(INDEX(total,MATCH($A$26,total1,0),0))="A"),INDEX(total,MATCH($A$26,total1,0),0)),"NoData")
Hello,
This will be a rough guess, but the formula should turn to be something like this
=IFERROR(LOOKUP(2,1/((LEFT(INDEX(total,MATCH($A$26,total1,0),0))="A")+(LEFT(INDEX(total,MATCH($A$26,total1,0),0))="vc")),INDEX(total,MATCH($A$26,total1,0),0)),"NoData")
(copy pasta from Ford)
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
Regards,
Lem
Thamks Lem,
Yor adaption works for "A" and "NoData" on those instances but doesn't pick up "vc"
Perhaps a small sample workbook? Just to see how your data looks like?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
test file attached
one instance of each criteria in yellow on schedule . search range highlighted in green
formula i3:i6 PRIORITY SHEET
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks