Fruits And Veg.xlsx
Hi All,
I'm trying to create a check within a workbook. Basically, the formula should match the value in column A to either the values listed in column H or I. In the even that there is a match, I need it to return the name of the column. I've attached a workbook with what I've got so far.
Please let me know if I can provide any additional details.
match will be returning an error - NOT true or false
try
=IF(COUNTIF(H:H,A2)>0,"Fruit",IF(COUNTIF(I:I,A2)>0,"Veg",""))
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.
Give this formula a try =IF(NOT(ISERROR(MATCH(A2,$H$2:$H$4,0))), $H$1,IF(ISERROR(MATCH(A2,$I$2:$I$4,0)),"",$I$1))
If for some reason you would like to stick to MATCH then this shall work fine:
but of course COUNTIF is more naturalFormula:
Please Login or Register to view this content.
Best Regards,
Kaper
Or this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Awesome! I ended up going with the =IF(COUNTIF(H:H,A2)>0,"Fruit",IF(COUNTIF(I:I,A2)>0,"Veg","")) formula. It worked out perfectly once I tweaked it to fit my live data.
Thanks guys! I appreciate the quick turn-around!
You guys rock!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks