Hi,
Can anyone help me with a formula please...
I need a formula to go in column “B” which looks up the contents of Column A and matches it with a table on another sheet “product group”.
If there is a match I need it to return the contents of the data table (1st column only)
If there isn’t a match I need it to return “other”
I have uploaded an example which will explain it better than I have above.
Any suggestions?
Paul
Last edited by pauldaddyadams; 04-10-2012 at 09:10 AM.
Try this formula in cell C2 and copy down:
=IF(COUNTIF('Product Group'!$C$5:$F$22,A2),INDEX('Product Group'!B:B,MAX(INDEX(ROW('Product Group'!$C$5:$F$22)*('Product Group'!$C$5:$F$22=A2),0))),"Doesn't appear in product group sheet")
Last edited by Andrew-R; 04-10-2012 at 07:45 AM. Reason: Can't spell "Doesn't"
Thanks Andrew - worked brilliantly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks