LinkBack URL
About LinkBacks
Hi Folks
Looked a simple one even for mebut I could not get it to work.
Lookup a value in a cell to see if there is a match in Col A of another sheet and return "1" if matched and "0" if no match.
Workbook attached.
Cheers
Hammer
Hi Folks
Looked a simple one even for me
Lookup a value in a cell to see if there is a match in Col A of another sheet and return "1" if matched and "0" if no match.
Workbook attached.
Cheers
Hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
Try this...
=IF(ISNUMBER(MATCH(I1,Table!A1:A7,0)),1,0)
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Or,
=IF(ISERROR(VLOOKUP(I1,Table!A:A,1)),0,1)
Hi Glenn
That formula is one that I did try without success in my actual Workbook.
The value I am looking up is the result of another formula- could that present a problem?
Cheers
hammer
Same problem there too cba-
Just going to review my Data sheet. Has to be a problem there-
Look for extra spaces...
found those extra spaces--- between my ears
Had a heading/col missing grrrrrrrrrr
Many thanks folks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks