Excel Loop Lookup
Closed
InvDR
-
Nov 19, 2014 at 08:50 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 19, 2014 at 09:17 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 19, 2014 at 09:17 PM
Related:
- Excel Loop Lookup
- Game loop - Download - Android emulators
- Excel marksheet - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Fruity loop download - Download - Musical production
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 19, 2014 at 09:17 PM
Nov 19, 2014 at 09:17 PM
InvDR, Good evening.
........A.........B........C..................D.............
1...Store...Part....K or R.....New K or R
2......1.......ABC.......R............=FORMULA
3......2.......ABC.......K............
4......3.......ABC.......R............
5......1.......KLM.......K............
6......2.......KLM.......K............
7......3.......KLM.......R............
8......1.......QRS.......R............
9......2.......QRS.......R............
10....3.......QRS.......K............
11....2.......XYZ.......R............
12....3.......XYZ.......K............
Try to do:
D2 --> =IF(COUNTIFS($B$2:$B$12,B3;$C$2:$C$12,"K")>0,"K","R")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
........A.........B........C..................D.............
1...Store...Part....K or R.....New K or R
2......1.......ABC.......R............=FORMULA
3......2.......ABC.......K............
4......3.......ABC.......R............
5......1.......KLM.......K............
6......2.......KLM.......K............
7......3.......KLM.......R............
8......1.......QRS.......R............
9......2.......QRS.......R............
10....3.......QRS.......K............
11....2.......XYZ.......R............
12....3.......XYZ.......K............
Try to do:
D2 --> =IF(COUNTIFS($B$2:$B$12,B3;$C$2:$C$12,"K")>0,"K","R")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão