LinkBack URL
About LinkBacks
I am looking for a formula that will search data from 2 cells against another table/book and return the info that matches those 2 cells.
(Hope the attachement works... I got some error when uploading it)
I am looking for a formula that will search data from 2 cells against another table/book and return the info that matches those 2 cells.
(Hope the attachement works... I got some error when uploading it
Joe O Ceadaigh,
Because the information you're returning is a number (price), you can use Sumifs. So using your provided example, in cell C23 and copied down:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks Tiger,
Unfortunately I have information I need to pull from multiple books and not all are number... some are text.
For example if I wanted the colour to be included... what would be the formula?
Then it gets a bit more complicated. I personally prefer Index/Match/Index for something like that. The basic format of the formula is:
=INDEX(OutputValues,MATCH(1,INDEX((CriteriaRange1=Criteria1)*(CriteriaRange2=Criteria2)*(CriteriaRange3=Criteria3)*(etc...),),0))
So, using your provided workbook, and because you are only matching 2 criteria to return the color, you would use the formula like this in cell C23 and copied down:
Please Login or Register to view this content.
Thanks again Tiger... I will give that a try and see how I get on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks