I need to create a formula that searches a specific row for criteria 2 then/and searches a specific column for criteria 2 and gives corresponding cell reference back to me.
I have attached a sample spreadsheet to help!!
Thanks!!
I need to create a formula that searches a specific row for criteria 2 then/and searches a specific column for criteria 2 and gives corresponding cell reference back to me.
I have attached a sample spreadsheet to help!!
Thanks!!
I mean search for Criteria 1 then Critera 2
There's no criteria in table 1 that appears to relate to table 2, can you add a table that will show your criteria and the results you expect it to display? For example, how does Agency 1 in table 1 relate to units or anything else for that matter in table 2?
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
I attached two examples on the bottom of the worksheet. Hope that helps!! I need to search two different ranges for two different but specific criteria to return the corresponding data.
Thanks!!
And of course there was an error in the attachment...corrected here!! Thanks!
Ok, i have to say i'm still not totally clear what data you want pulled from where and displayed where but try these samples. If they're close, delete the data thats not relevant and see how we go from there. I've pt a couple of DV lists in just for ease of use
My turn for the mistake, forgot to put this formula in B36 and drag down
INDEX($B$20:$E$24,MATCH(A36,$A$20:$A$24,0),MATCH($B$35,$B$19:$E$19,0))
Last edited by scottylad2; 03-15-2011 at 02:20 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks