F5F Stay Refreshed Hardware Desktop A challenging method tailored for LibreOffice or Excel.

A challenging method tailored for LibreOffice or Excel.

A challenging method tailored for LibreOffice or Excel.

R
RagingTiger
Junior Member
Find
3
09-07-2016, 12:05 AM
#1
In cell A1 there are three precise figures. In column C1 you intended to list three exact names, but one is absent from your records. Can someone help resolve this issue? I'm using LibreOffice, though if the answer applies only to Excel, I’ll consider purchasing it.
Reply
Reply
R
RagingTiger
09-07-2016, 12:05 AM #1

In cell A1 there are three precise figures. In column C1 you intended to list three exact names, but one is absent from your records. Can someone help resolve this issue? I'm using LibreOffice, though if the answer applies only to Excel, I’ll consider purchasing it.

Reply
Reply
U
umizou1393
Senior Member
Find
253
09-12-2016, 05:06 PM
#2
=SEERRO(Index(B1:B8000; Corres(A1; A8000; 0); "test"))
Reply
Reply
U
umizou1393
09-12-2016, 05:06 PM #2

=SEERRO(Index(B1:B8000; Corres(A1; A8000; 0); "test"))

Reply
Reply