![]() |
Help on matching some cells
Hi
I have a list that will have a reference number in column A from 1 to 2000 with additional information in column b and c. so will be like A B C D 1 yes 23 (blank) I will be pasting a list under this list with the same setup excet in column d it will have another reference point such as 10. A B C D 1 yes 23 10 The list will be contain most of the top list and i would like to top list to check the list underneath matching the reference number and to return what is in column D on the new list to match what is in column D on the new list there will be a few that don't match and could be highlighted False so i can deal with them. Any ideas would be great as i know there is a lookup function but not sure what is best to do.( and easiest). Many thanks for looking |
Help on matching some cells
Use column E as a (temporary) helper column, and put this formula in
E1: =A1&B1&C1 Copy this down your first list, and then continue copying it down your second list. Then put this formula in D1: =IF(ISNA(MATCH(E1,E$2010:E$5000,0)),FALSE,INDEX(D$ 2010:D $5000,MATCH(E1,E$2010:E$5000,0))) Copy this down your first list. I have assumed your second list occupies rows 2010 to 5000 - adjust to suit. Once the formula is copied down column D, you can fix the values and then delete column E. Hope this helps. Pete On Mar 19, 4:33*pm, Neil wrote: Hi I have a list that will have a reference number in column A from 1 to 2000 with additional information in column b and c. so will be like A * * * B * * * C * * * D 1 * * *yes * * 23 * * (blank) I will be pasting a list under this list with the same setup excet in column d it will have another reference point such as 10. A * * * B * * * C * * * D 1 * * *yes * * 23 * * 10 The list will be contain most of the top list and i would like to top list to check the list underneath matching the reference number and to return what is in column D on the new list to match what is in column D on the new list there will be a few that don't match and could be highlighted False so i can deal with them. Any ideas would be great as i know there is a lookup function but not sure what is best to do.( and easiest). Many thanks for looking |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com