Match value from a specific cell with the same value in multiple columns, return the results of these rows from a specific column

S

Silverhorne

New Member
Joined
Feb 21, 2015
Messages
42
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Good day,
I have been trying to clean up my spread sheet by removing helper columns and can't figure out how o do it.
I have a main log with all of my data and another sheet as a request. I am trying to populate the request based on the contents in a specific cell matching the same contents on another sheet over multiple columns, then returning the data from another column. I would like to do this with formulas and not VBA. My original spreadsheet has 10 helper columns that I need to get rid of; other people keep deleting the contents and adding rows, not knowing the formulas are there.

ABCDEFGHI
Iso 54waterBill
Iso 54gasFrankRequest 1
Iso 52nitrogenDave
Iso 54gasDaveRequest 1
Iso 54nitrogenFrank
Iso 54waterFrankRequest 1
Iso 54waterFrank
Iso 52nitrogenFrank
Iso 53nitrogenDave
Iso 54nitrogenBillRequest 1
Iso 53nitrogenDave
Iso 53waterBill
Iso 53waterBillRequest 1
Iso 54gasDave
Iso 52gasBill
Iso 52nitrogenBill
Iso 54gasFrankRequest 1
Iso 53gasDave
Iso 53waterBill
Iso 54nitrogenFrank
Iso 52waterDaveRequest 1
Iso 54waterBill

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Data[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]2
[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]Helper[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Drawing[/TD]
[TD="align: center"]Line#[/TD]
[TD="align: center"]Person[/TD]
[TD="align: right"][/TD]
[TD="align: center"]6am[/TD]
[TD="align: center"]Noon[/TD]
[TD="align: center"]6pm[/TD]
[TD="align: center"]Midnight[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: center"]5[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]
[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: center"]7[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Log​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A5[/TH]
[TD="align: left"]=IF(OR(F5=Request!F1,G5=Request!F1,H5=Request!F1,I5=Request!F1),1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A6[/TH]
[TD="align: left"]=IF(OR(F6=Request!$F$1,G6=Request!$F$1,H6=Request!$F$1,I6=Request!$F$1),MAX($A$5:$A5)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A7[/TH]
[TD="align: left"]=IF(OR(F7=Request!$F$1,G7=Request!$F$1,H7=Request!$F$1,I7=Request!$F$1),MAX($A$5:$A6)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A8[/TH]
[TD="align: left"]=IF(OR(F8=Request!$F$1,G8=Request!$F$1,H8=Request!$F$1,I8=Request!$F$1),MAX($A$5:$A7)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A9[/TH]
[TD="align: left"]=IF(OR(F9=Request!$F$1,G9=Request!$F$1,H9=Request!$F$1,I9=Request!$F$1),MAX($A$5:$A8)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A10[/TH]
[TD="align: left"]=IF(OR(F10=Request!$F$1,G10=Request!$F$1,H10=Request!$F$1,I10=Request!$F$1),MAX($A$5:$A9)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A11[/TH]
[TD="align: left"]=IF(OR(F11=Request!$F$1,G11=Request!$F$1,H11=Request!$F$1,I11=Request!$F$1),MAX($A$5:$A10)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A12[/TH]
[TD="align: left"]=IF(OR(F12=Request!$F$1,G12=Request!$F$1,H12=Request!$F$1,I12=Request!$F$1),MAX($A$5:$A11)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A13[/TH]
[TD="align: left"]=IF(OR(F13=Request!$F$1,G13=Request!$F$1,H13=Request!$F$1,I13=Request!$F$1),MAX($A$5:$A12)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A14[/TH]
[TD="align: left"]=IF(OR(F14=Request!$F$1,G14=Request!$F$1,H14=Request!$F$1,I14=Request!$F$1),MAX($A$5:$A13)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A15[/TH]
[TD="align: left"]=IF(OR(F15=Request!$F$1,G15=Request!$F$1,H15=Request!$F$1,I15=Request!$F$1),MAX($A$5:$A14)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A16[/TH]
[TD="align: left"]=IF(OR(F16=Request!$F$1,G16=Request!$F$1,H16=Request!$F$1,I16=Request!$F$1),MAX($A$5:$A15)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A17[/TH]
[TD="align: left"]=IF(OR(F17=Request!$F$1,G17=Request!$F$1,H17=Request!$F$1,I17=Request!$F$1),MAX($A$5:$A16)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A18[/TH]
[TD="align: left"]=IF(OR(F18=Request!$F$1,G18=Request!$F$1,H18=Request!$F$1,I18=Request!$F$1),MAX($A$5:$A17)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A19[/TH]
[TD="align: left"]=IF(OR(F19=Request!$F$1,G19=Request!$F$1,H19=Request!$F$1,I19=Request!$F$1),MAX($A$5:$A18)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A20[/TH]
[TD="align: left"]=IF(OR(F20=Request!$F$1,G20=Request!$F$1,H20=Request!$F$1,I20=Request!$F$1),MAX($A$5:$A19)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A21[/TH]
[TD="align: left"]=IF(OR(F21=Request!$F$1,G21=Request!$F$1,H21=Request!$F$1,I21=Request!$F$1),MAX($A$5:$A20)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A22[/TH]
[TD="align: left"]=IF(OR(F22=Request!$F$1,G22=Request!$F$1,H22=Request!$F$1,I22=Request!$F$1),MAX($A$5:$A21)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A23[/TH]
[TD="align: left"]=IF(OR(F23=Request!$F$1,G23=Request!$F$1,H23=Request!$F$1,I23=Request!$F$1),MAX($A$5:$A22)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A24[/TH]
[TD="align: left"]=IF(OR(F24=Request!$F$1,G24=Request!$F$1,H24=Request!$F$1,I24=Request!$F$1),MAX($A$5:$A23)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A25[/TH]
[TD="align: left"]=IF(OR(F25=Request!$F$1,G25=Request!$F$1,H25=Request!$F$1,I25=Request!$F$1),MAX($A$5:$A24)+1,"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A26[/TH]
[TD="align: left"]=IF(OR(F26=Request!$F$1,G26=Request!$F$1,H26=Request!$F$1,I26=Request!$F$1),MAX($A$5:$A25)+1,"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



ABCDEF
Iso 54gasFrank
Iso 54gasDave
Iso 54waterFrank
Iso 54nitrogenBill
Iso 53waterBill
Iso 54gasFrank
Iso 52waterDave

<colgroup><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00"]Request 1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Helper[/TD]
[TD="align: center"]Drawing[/TD]
[TD="align: center"]Line#[/TD]
[TD="align: center"]Person[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]
[TD="align: center"] [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Request​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A5[/TH]
[TD="align: left"]=IF(MIN(Log!$A$5:$A26)=0," ",MIN(Log!$A$5:$A26))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B5[/TH]
[TD="align: left"]=IF(ISNA(IF($A5=" "," ",LOOKUP($A5,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A5=" "," ",LOOKUP($A5,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C5[/TH]
[TD="align: left"]=IF(ISNA(IF($A5=" "," ",LOOKUP($A5,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A5=" "," ",LOOKUP($A5,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D5[/TH]
[TD="align: left"]=IF(ISNA(IF($A5=" "," ",LOOKUP($A5,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A5=" "," ",LOOKUP($A5,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A6[/TH]
[TD="align: left"]=IF(A5>=(MAX(Log!$A$5:$A26))," ",MIN(Log!$A$5:$A26)+COUNT($A$5:$A5))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B6[/TH]
[TD="align: left"]=IF(ISNA(IF($A6=" "," ",LOOKUP($A6,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A6=" "," ",LOOKUP($A6,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C6[/TH]
[TD="align: left"]=IF(ISNA(IF($A6=" "," ",LOOKUP($A6,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A6=" "," ",LOOKUP($A6,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D6[/TH]
[TD="align: left"]=IF(ISNA(IF($A6=" "," ",LOOKUP($A6,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A6=" "," ",LOOKUP($A6,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A7[/TH]
[TD="align: left"]=IF(A6>=(MAX(Log!$A$5:$A27))," ",MIN(Log!$A$5:$A27)+COUNT($A$5:$A6))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B7[/TH]
[TD="align: left"]=IF(ISNA(IF($A7=" "," ",LOOKUP($A7,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A7=" "," ",LOOKUP($A7,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C7[/TH]
[TD="align: left"]=IF(ISNA(IF($A7=" "," ",LOOKUP($A7,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A7=" "," ",LOOKUP($A7,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D7[/TH]
[TD="align: left"]=IF(ISNA(IF($A7=" "," ",LOOKUP($A7,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A7=" "," ",LOOKUP($A7,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A8[/TH]
[TD="align: left"]=IF(A7>=(MAX(Log!$A$5:$A28))," ",MIN(Log!$A$5:$A28)+COUNT($A$5:$A7))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B8[/TH]
[TD="align: left"]=IF(ISNA(IF($A8=" "," ",LOOKUP($A8,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A8=" "," ",LOOKUP($A8,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C8[/TH]
[TD="align: left"]=IF(ISNA(IF($A8=" "," ",LOOKUP($A8,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A8=" "," ",LOOKUP($A8,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D8[/TH]
[TD="align: left"]=IF(ISNA(IF($A8=" "," ",LOOKUP($A8,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A8=" "," ",LOOKUP($A8,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A9[/TH]
[TD="align: left"]=IF(A8>=(MAX(Log!$A$5:$A29))," ",MIN(Log!$A$5:$A29)+COUNT($A$5:$A8))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B9[/TH]
[TD="align: left"]=IF(ISNA(IF($A9=" "," ",LOOKUP($A9,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A9=" "," ",LOOKUP($A9,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C9[/TH]
[TD="align: left"]=IF(ISNA(IF($A9=" "," ",LOOKUP($A9,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A9=" "," ",LOOKUP($A9,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D9[/TH]
[TD="align: left"]=IF(ISNA(IF($A9=" "," ",LOOKUP($A9,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A9=" "," ",LOOKUP($A9,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A10[/TH]
[TD="align: left"]=IF(A9>=(MAX(Log!$A$5:$A30))," ",MIN(Log!$A$5:$A30)+COUNT($A$5:$A9))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B10[/TH]
[TD="align: left"]=IF(ISNA(IF($A10=" "," ",LOOKUP($A10,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A10=" "," ",LOOKUP($A10,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C10[/TH]
[TD="align: left"]=IF(ISNA(IF($A10=" "," ",LOOKUP($A10,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A10=" "," ",LOOKUP($A10,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D10[/TH]
[TD="align: left"]=IF(ISNA(IF($A10=" "," ",LOOKUP($A10,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A10=" "," ",LOOKUP($A10,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A11[/TH]
[TD="align: left"]=IF(A10>=(MAX(Log!$A$5:$A31))," ",MIN(Log!$A$5:$A31)+COUNT($A$5:$A10))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B11[/TH]
[TD="align: left"]=IF(ISNA(IF($A11=" "," ",LOOKUP($A11,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A11=" "," ",LOOKUP($A11,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C11[/TH]
[TD="align: left"]=IF(ISNA(IF($A11=" "," ",LOOKUP($A11,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A11=" "," ",LOOKUP($A11,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D11[/TH]
[TD="align: left"]=IF(ISNA(IF($A11=" "," ",LOOKUP($A11,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A11=" "," ",LOOKUP($A11,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A12[/TH]
[TD="align: left"]=IF(A11>=(MAX(Log!$A$5:$A32))," ",MIN(Log!$A$5:$A32)+COUNT($A$5:$A11))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B12[/TH]
[TD="align: left"]=IF(ISNA(IF($A12=" "," ",LOOKUP($A12,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A12=" "," ",LOOKUP($A12,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C12[/TH]
[TD="align: left"]=IF(ISNA(IF($A12=" "," ",LOOKUP($A12,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A12=" "," ",LOOKUP($A12,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D12[/TH]
[TD="align: left"]=IF(ISNA(IF($A12=" "," ",LOOKUP($A12,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A12=" "," ",LOOKUP($A12,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A13[/TH]
[TD="align: left"]=IF(A12>=(MAX(Log!$A$5:$A33))," ",MIN(Log!$A$5:$A33)+COUNT($A$5:$A12))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B13[/TH]
[TD="align: left"]=IF(ISNA(IF($A13=" "," ",LOOKUP($A13,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A13=" "," ",LOOKUP($A13,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C13[/TH]
[TD="align: left"]=IF(ISNA(IF($A13=" "," ",LOOKUP($A13,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A13=" "," ",LOOKUP($A13,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D13[/TH]
[TD="align: left"]=IF(ISNA(IF($A13=" "," ",LOOKUP($A13,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A13=" "," ",LOOKUP($A13,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A14[/TH]
[TD="align: left"]=IF(A13>=(MAX(Log!$A$5:$A34))," ",MIN(Log!$A$5:$A34)+COUNT($A$5:$A13))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B14[/TH]
[TD="align: left"]=IF(ISNA(IF($A14=" "," ",LOOKUP($A14,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A14=" "," ",LOOKUP($A14,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C14[/TH]
[TD="align: left"]=IF(ISNA(IF($A14=" "," ",LOOKUP($A14,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A14=" "," ",LOOKUP($A14,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D14[/TH]
[TD="align: left"]=IF(ISNA(IF($A14=" "," ",LOOKUP($A14,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A14=" "," ",LOOKUP($A14,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A15[/TH]
[TD="align: left"]=IF(A14>=(MAX(Log!$A$5:$A35))," ",MIN(Log!$A$5:$A35)+COUNT($A$5:$A14))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B15[/TH]
[TD="align: left"]=IF(ISNA(IF($A15=" "," ",LOOKUP($A15,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A15=" "," ",LOOKUP($A15,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C15[/TH]
[TD="align: left"]=IF(ISNA(IF($A15=" "," ",LOOKUP($A15,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A15=" "," ",LOOKUP($A15,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D15[/TH]
[TD="align: left"]=IF(ISNA(IF($A15=" "," ",LOOKUP($A15,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A15=" "," ",LOOKUP($A15,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A16[/TH]
[TD="align: left"]=IF(A15>=(MAX(Log!$A$5:$A36))," ",MIN(Log!$A$5:$A36)+COUNT($A$5:$A15))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B16[/TH]
[TD="align: left"]=IF(ISNA(IF($A16=" "," ",LOOKUP($A16,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A16=" "," ",LOOKUP($A16,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C16[/TH]
[TD="align: left"]=IF(ISNA(IF($A16=" "," ",LOOKUP($A16,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A16=" "," ",LOOKUP($A16,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D16[/TH]
[TD="align: left"]=IF(ISNA(IF($A16=" "," ",LOOKUP($A16,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A16=" "," ",LOOKUP($A16,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A17[/TH]
[TD="align: left"]=IF(A16>=(MAX(Log!$A$5:$A37))," ",MIN(Log!$A$5:$A37)+COUNT($A$5:$A16))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B17[/TH]
[TD="align: left"]=IF(ISNA(IF($A17=" "," ",LOOKUP($A17,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A17=" "," ",LOOKUP($A17,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C17[/TH]
[TD="align: left"]=IF(ISNA(IF($A17=" "," ",LOOKUP($A17,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A17=" "," ",LOOKUP($A17,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D17[/TH]
[TD="align: left"]=IF(ISNA(IF($A17=" "," ",LOOKUP($A17,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A17=" "," ",LOOKUP($A17,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A18[/TH]
[TD="align: left"]=IF(A17>=(MAX(Log!$A$5:$A38))," ",MIN(Log!$A$5:$A38)+COUNT($A$5:$A17))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B18[/TH]
[TD="align: left"]=IF(ISNA(IF($A18=" "," ",LOOKUP($A18,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A18=" "," ",LOOKUP($A18,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C18[/TH]
[TD="align: left"]=IF(ISNA(IF($A18=" "," ",LOOKUP($A18,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A18=" "," ",LOOKUP($A18,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D18[/TH]
[TD="align: left"]=IF(ISNA(IF($A18=" "," ",LOOKUP($A18,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A18=" "," ",LOOKUP($A18,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A19[/TH]
[TD="align: left"]=IF(A18>=(MAX(Log!$A$5:$A39))," ",MIN(Log!$A$5:$A39)+COUNT($A$5:$A18))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B19[/TH]
[TD="align: left"]=IF(ISNA(IF($A19=" "," ",LOOKUP($A19,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A19=" "," ",LOOKUP($A19,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C19[/TH]
[TD="align: left"]=IF(ISNA(IF($A19=" "," ",LOOKUP($A19,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A19=" "," ",LOOKUP($A19,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D19[/TH]
[TD="align: left"]=IF(ISNA(IF($A19=" "," ",LOOKUP($A19,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A19=" "," ",LOOKUP($A19,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A20[/TH]
[TD="align: left"]=IF(A19>=(MAX(Log!$A$5:$A40))," ",MIN(Log!$A$5:$A40)+COUNT($A$5:$A19))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B20[/TH]
[TD="align: left"]=IF(ISNA(IF($A20=" "," ",LOOKUP($A20,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A20=" "," ",LOOKUP($A20,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C20[/TH]
[TD="align: left"]=IF(ISNA(IF($A20=" "," ",LOOKUP($A20,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A20=" "," ",LOOKUP($A20,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D20[/TH]
[TD="align: left"]=IF(ISNA(IF($A20=" "," ",LOOKUP($A20,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A20=" "," ",LOOKUP($A20,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A21[/TH]
[TD="align: left"]=IF(A20>=(MAX(Log!$A$5:$A41))," ",MIN(Log!$A$5:$A41)+COUNT($A$5:$A20))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B21[/TH]
[TD="align: left"]=IF(ISNA(IF($A21=" "," ",LOOKUP($A21,Log!$A$5:$A$26,Log!$B$5:$B$26))),"",IF($A21=" "," ",LOOKUP($A21,Log!$A$5:$A$26,Log!$B$5:$B$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C21[/TH]
[TD="align: left"]=IF(ISNA(IF($A21=" "," ",LOOKUP($A21,Log!$A$5:$A$26,Log!$C$5:$C$26))),"",IF($A21=" "," ",LOOKUP($A21,Log!$A$5:$A$26,Log!$C$5:$C$26)))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D21[/TH]
[TD="align: left"]=IF(ISNA(IF($A21=" "," ",LOOKUP($A21,Log!$A$5:$A$26,Log!$D$5:$D$26))),"",IF($A21=" "," ",LOOKUP($A21,Log!$A$5:$A$26,Log!$D$5:$D$26)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
How about


Book1
ABCDE
1Request 1
2
3
4DrawingLine#Person
5Iso 54gasFrank
6Iso 54gasDave
7Iso 54waterFrank
8Iso 54nitrogenBill
9Iso 53waterBill
10Iso 54gasFrank
11Iso 52waterDave
Request
Cell Formulas
RangeFormula
A5=IFERROR(INDEX(Log!B$5:B$26,AGGREGATE(15,6,(ROW(Log!$B$5:$B$26)-ROW(Log!$B$5)+1)/(Log!$F$5:$I$25=$E$1),ROWS($A$1:$A1))),"")
B5=IFERROR(INDEX(Log!C$5:C$26,AGGREGATE(15,6,(ROW(Log!$B$5:$B$26)-ROW(Log!$B$5)+1)/(Log!$F$5:$I$25=$E$1),ROWS($A$1:$A1))),"")
C5=IFERROR(INDEX(Log!D$5:D$26,AGGREGATE(15,6,(ROW(Log!$B$5:$B$26)-ROW(Log!$B$5)+1)/(Log!$F$5:$I$25=$E$1),ROWS($A$1:$A1))),"")
 
Upvote 0
Solution
Thank you Fluff for the quick response! I didn't think when I made the sample sheet and had all the columns with the "Request 1" in the log next to each other. Is it possible to change this "(Log!$F$5:$I$25=$E$1)" to individual columns that will have populated columns between them? I tied to imbed an "OR" statement but it didn't work the way I did it.
I'll have to work through it to see exactly what's going on, I don't understand the "ROWS($A$1:$A1)" this point, I've never used the AGGREGATE formula before.
 
Upvote 0
As long as the other columns don't contain "Request 1" then simply change this
Log!$F$5:$I$25=$E$1
to reference the full range you want to look at like
Log!$F$5:$N$25=$E$1
 
Upvote 0
I will shuffle some columns around to make sure none of the ones between will need to have the request number in them. I appreciate the help, thank you again!
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0
You must log in or register to reply here.

Similar threads

willow1985
  • Question Question
Macro to Copy Folder and all its contents (including subfolders) to a new location based on a list
Replies
6
Views
187
Tupacandres
T
C
  • Question Question
Search/Find specific word or match in multiple columns and highlight the cells that do not match
Replies
1
Views
37
chueeee
C
S
  • Solved
Pairwise Comparison Table
Replies
4
Views
363
Samgraphics
S
R
  • Solved
How to independently sort multiple columns of this SEQUENCE output without effecting the positions of the columns and of the blanks?
2
Replies
15
Views
519
Rnkhch
R
M
  • Solved
return value based on the number that matches any number in three columns
Replies
3
Views
143
MMM_84
M

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top