If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need help desperately !! I need a formula that will allow me to match cells...
I need a formula that will allow me to match 2 cells from 2 different
columns on one sheet to two columns on another sheet. Then if they match I need the data from another column (same row) to be put in on the 1st sheet. If anyone can help I would be most appreciative as I am pulling my hair out here ! I can email any more info as is necessary, as I would imagine that you will need the sheet to look at with a better explanation! Thanks guys url:http://www.ureader.com/gp/1042-1.aspx |
#2
|
|||
|
|||
I need help desperately !! I need a formula that will allow me to match cells...
Don't email... just post more description. For example, what 2 cells from
what 2 columns on which sheet (give us rows, columns and sheet name)? When you say 2 columns on another sheet, what do you mean... are you trying to see if the one of the cells is located within a range in one column and the other cell is located within a range in the second column? If so, what columns go with what cells (and what is the sheet name containing these 2 columns)? Is the look up an "and" (both cells must be found in their respective columns) or an "or" (at least one of the cells must be found, but not necessarily both cells)? Remember, you know what you are doing while we have no idea... so you have to tell us in your description of the problem. -- Rick (MVP - Excel) "phillip warren" wrote in message .. . I need a formula that will allow me to match 2 cells from 2 different columns on one sheet to two columns on another sheet. Then if they match I need the data from another column (same row) to be put in on the 1st sheet. If anyone can help I would be most appreciative as I am pulling my hair out here ! I can email any more info as is necessary, as I would imagine that you will need the sheet to look at with a better explanation! Thanks guys url:http://www.ureader.com/gp/1042-1.aspx |
#3
|
|||
|
|||
I need help desperately !! I need a formula that will allow me to
Hi Phillip,
Ok I am assuming that you have sheet1 and sheet 2 columns A & B with the information to be matched and you want the results from Sheet 2 column C total rows assumed from 1 to 30000 change to fit your needs =sumproduct(--(a1=sheet2!$a$1:$a$30000),--(b1=sheet2!$B$1:$b$30000),sheet2!$c$1:$c$30000) If this was helpful please click yes. thank you "phillip warren" wrote: I need a formula that will allow me to match 2 cells from 2 different columns on one sheet to two columns on another sheet. Then if they match I need the data from another column (same row) to be put in on the 1st sheet. If anyone can help I would be most appreciative as I am pulling my hair out here ! I can email any more info as is necessary, as I would imagine that you will need the sheet to look at with a better explanation! Thanks guys url:http://www.ureader.com/gp/1042-1.aspx |
Thread Tools | |
Display Modes | |
|
|