#1
|
|||
|
|||
Compair two pair of cells: function usage
Hello!
I'm looking for a way to do the following: -Compare a pair of cells on sheet A to another pair of cells on sheet B. -If the pairs match (only one match will be possible), return the value from the column on sheet B corresponding to that matched pair. Can somebody help me? |
#2
|
|||
|
|||
Try =INDEX(Sheet11!$C$1:$C$3,MATCH(Sheet10!A1&Sheet10! B1,Sheet11!$A$1:$A$3&Sheet11!$B$1:$B$3,0))
Sheet11 is your sheet B and sheet10 is your sheet A |
#3
|
|||
|
|||
Thanks for the reply, unfortunately it didn't work.
I uploaded the original file. What I'm trying to do is: -In sheet REDE COLETORA DE ESGOTO match the pair of cells on column B and C with the corresponding pair in sheet APOIO. -In sheet REDE COLETORA DE ESGOTO column D return the value from sheet APOIO column D that corresponds to the matched pair. Can anyone give it a go on the original spreadsheet? |
#4
|
||||
|
||||
Cross-posts:
Compair two pair of cells: function usage | Chandoo.org Excel Forums - Become Awesome in Excel Compair two pair of cells: function usage | MrExcel Message Board https://www.excelforum.com/excel-for...ion-usage.html |
#5
|
|||
|
|||
Remove the @ in front of APOIO. Must get rid of merged cells. Formula works for row 13 but will not copy down because of merged cells.
|
#6
|
||||
|
||||
Also cross posted at Compair two pair of cells: function usage - Microsoft Community Hub
and Compair two pair of cells: function usage | General Excel Questions & Answers | Excel Forum | My Online Training Hub
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SubTotal function counts the blank cells with formula | LearnerExcel | Excel | 3 | 12-29-2019 04:54 AM |
Help with Index Function to Select Range of Cells | bretyuin | Excel | 1 | 02-24-2016 05:11 AM |
Linking specific cells in Excel to function with MergeField? | Fabulist | Word | 0 | 02-17-2016 02:19 AM |
multiple conditions, and blank cells with the countifs function | jaden0605 | Excel | 1 | 03-30-2014 01:50 AM |
mapping from token to text/number pair | JettyGuy | Word | 0 | 08-13-2011 10:47 AM |