Hi,
I am using - on tab "Front Page"
=IF(COUNTIFS(FINAL!$E$10:$E$30,SKU!$A$2:$A$1782),lists!$A$30,FALSE)
What I would like to do is -
If in E10:E30 on "Final Tab" a sku # exits that is then found on sku tab A2:A1782 as well as in column G on sku tab is denoted as "Standard" then I would like the value in A30 on "lists" tab returned.
This is a good one I think!
Thank you!
It's not clear what you are trying to do exactly. You certainly can't use COUNTIFS in the way you have attempted to do. Are you trying to generate just one result or a list of results? Please add the expected outcome(s) manually on your final tab so that we can see what you are trying to achieve. How is Excel meant to associate SKUs with the items on the List sheet?
Last edited by AliGW; 05-30-2017 at 02:45 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Need to see some sample answers
Not sure what you are testing or where you want the answer
This will do the search based on what is in E10 on Final sheet
=IF(INDEX(SKU!G:G,MATCH(E10,SKU!A:A,0))="STANDARD",lists!$A$30,"")
when you put this in a helper column (I used AB10) and copied down, it returns A30 where applicable - but ONLY A30
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ali,
I started again with this in Cell B38 on Front page tab -
=IF(VLOOKUP(FINAL!E10,SKU!$A:$H,7,FALSE)="Standard",lists!$A$30,IF(VLOOKUP(FINAL!E10,SKU!$A:$H,7,FALSE)="FR",lists!$A$32,IF(VLOOKUP(FINAL!E10,SKU!$A:$H,7,FALSE)="Polo",lists!$A$32,IF(VLOOKUP(FINAL!E10,SKU!$A:$H,7,FALSE)="T-SHIRT",lists!$A$33,IF(VLOOKUP(FINAL!E10,SKU!$A:$H,7,FALSE)="CARHARTT",lists!$A$32,"-")))))
Hi Ford,
I am trying to do this (that can't be done, I think) - I think I was trying to get Excel to return two values to one cell.
Here was my thinking -
Look at Final Tab cells E10:E30,
If any of the sku numbers there, are also found on SKU tab in range A2:A1782, then return the value from column G on SKU tab for the corresponding sku in column A.
Not sure that makes sense.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks