• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup

S

Shabbo

Member
Dear Sir,

I wanted to lookup Vehicle no from F column to Vehicle no from V column is matching.

In F column vehicle no after Advance Paid and in V column it only vehicle no how to lookup.
 

Attachments

  • Cash Entry file.xls
    20.5 KB · Views: 4
@Shabbo ... hmm?
If You would like to get V-column's row number for matching 'Vechile No'
write next to cell [A2] and copy down...
=IFERROR(MATCH(LEFT(MID(F2,14,99)&" ",12),V:V,0),"none")
but but ... someway not so clear, what do You really want to do?
 
vletm said:
@Shabbo ... hmm?
If You would like to get V-column's row number for matching 'Vechile No'
write next to cell [A2] and copy down...
=IFERROR(MATCH(LEFT(MID(F2,14,99)&" ",12),V:V,0),"none")
but but ... someway not so clear, what do You really want to do?
Click to expand...
Dear Sir,
Both Vehicle number should be same, if not then Payment made to wrong vehicle number; data is large so it takes time to check manually if formula helps then it will save time.

here I have pasted in B2 but its not working.
 
Shabbo
Aren't those F2 & V2 'Vechile number' same?
... and You didn't say WHERE do You would like to get something - or how?
As I tried to wrote - Write to Cell [A2] that formula!
Screen Shot 2017-04-01 at 18.11.13.png
and still, someway not so clear, what do You really want to do?
 
vletm said:
Shabbo
Aren't those F2 & V2 'Vechile number' same?
... and You didn't say WHERE do You would like to get something - or how?
As I tried to wrote - Write to Cell [A2] that formula!
View attachment 40273
and still, someway not so clear, what do You really want to do?
Click to expand...
Dear Sir,
In some cases it may not be the same.
If the Vehicle numbers are not same in It should show False as explain in my attached worksheet.
I want to ensure my vehicle number in NOTE and Vehicle number column both are matching.
 

Attachments

  • Cash Entry file.xls
    20.5 KB · Views: 6
original:
I wanted to lookup Vehicle no from F column to Vehicle no from V column is matching.
In F column vehicle no after Advance Paid and in V column it only vehicle no how to lookup.
NO MARKS of TRUE or FALSE -results!
Now, You changed ... so here is one possible TRUE/FALSE
=IFERROR(IF(MATCH(LEFT(MID(F2,14,99)&" ",12),V:V,0)>0,TRUE,FALSE),FALSE)
And of course, those could be different, but in sample, ALL MATCH!
 
vletm said:
original:
I wanted to lookup Vehicle no from F column to Vehicle no from V column is matching.
In F column vehicle no after Advance Paid and in V column it only vehicle no how to lookup.
NO MARKS of TRUE or FALSE -results!
Now, You changed ... so here is one possible TRUE/FALSE
=IFERROR(IF(MATCH(LEFT(MID(F2,14,99)&" ",12),V:V,0)>0,TRUE,FALSE),FALSE)
And of course, those could be different, but in sample, ALL MATCH!
Click to expand...
Its working exactly the way I want thank you.
 
If you just need to look across one row then you can use:
=ISNUMBER(SEARCH(TRIM(V2),F2))

vletm's formula will look through complete V column.
 
You must log in or register to reply here.
Back
Top