Posts by Niraj

try this..

=SUMIF(Master!B:B,E6,INDIRECT(N13))

also you can use this

"=LEFT(RIGHT(A1,12),6)"

Copy this "=INDEX(I10:I13,MATCH("*"&I4&"*"&"*"&I5&"*",H10:H13&H10:H13,0))" and press Ctrl+Shift+Enter

Check attached file.. This may help.

first make a list of patient name in a new worksheet, remove duplicate then assign codes.. after that you can use vlookup to replace patient name with code.

TRY THIS =INDEX(Sheet2!$B$2:$B$332,MATCH(A2,Sheet2!$A$2:$A$332,0))

Re: Lookup in columns and rows, mark match with "X"

why don't u try using PIVOT option.

see the attached file...

this may help u

Re: Create time stamp that includes milliseconds

see the attachment....................

Re: Vlookup using two conditions?

For this task, you should use INDEX & MATCH instead of VLOOKUP.

for example see attachment.