Forum Discussion
Solved
Vlookup or any better function
Dear Experts, Greetings! I have a data like below:- Sheet 1 & 2, and have to fetch the data from 2 -> 1. If , I use Vlookup with True(approximate match) then it populates ...
Does this do what you want?
=LET(t, IFERROR(LOOKUP(A2, '2'!A:A), ""), IF(COUNTIF(B$1:B1, t), "", t))
You mention "I want to populate the exact time", but there are no exact matches. So what is the expected/desired result?
Hi HansVogelaar , Sorry I wasn't clear earlier, I meant like this:-
So, in Column B(say) populate the time( blue) from the sheet2, which is just after the one in Column A in sheet-1
Does this do what you want?
=LET(t, IFERROR(LOOKUP(A2, '2'!A:A), ""), IF(COUNTIF(B$1:B1, t), "", t))
Let me give one more sample, So the
is just after22:50:56.637
and before22:50:56.645
so, I keep it after 22:50:56.645, in column B, and so on..22:50:56.707
