Hi Folks
Another one of these
In Sheet1 BO2 I want to look up the value in Sheet1 DQ2 and see if there is a match in Table! Col G
If so I want BO2 to return "1" else ""
Cheers
hammer
Hi Folks
Another one of these
In Sheet1 BO2 I want to look up the value in Sheet1 DQ2 and see if there is a match in Table! Col G
If so I want BO2 to return "1" else ""
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 using
=IF(ISNA(INDEX(Table!G:G, MATCH(DQ2,Table!G:G,0))), "",1)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
That looks the goods etaf!
Thanks a lot
your welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks