Please help me with a formula. I need a formula that will only look at text.
Basically, i need to look at a column of data and another column of data and if both data is what i needed, it will input in the cell another column of data.
I'm not really good at explaining so i've attached an excel file.
please help if you can, thx.
Last edited by NBVC; 02-10-2011 at 08:50 AM.
Try:
=INDEX(data!$C$12:$C$14,MATCH(1,INDEX((data!$A$12:$A$14=$A6)*(data!$B$12:$B$14=B$5),0),0))
formula can be copied across and/or down if you have more row/column headers.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
it works, thank you so much. I really appreciate this. thank you again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks