We loop-up
Closed
spmahawar
Posts
1
Registration date
Friday September 13, 2013
Status
Member
Last seen
September 13, 2013
-
Sep 13, 2013 at 09:57 AM
Blocked Profile - Sep 13, 2013 at 10:19 AM
Blocked Profile - Sep 13, 2013 at 10:19 AM
Related:
- We loop-up
- Fruity loop download - Download - Musical production
- Game loop - Download - Android emulators
- Microsoft loop - Download - Organisation and teamwork
- Discord update failed loop - Guide
- Loop recorder download - Download - Audio recording
1 response
Good Morning,
I am not certain I understand you question. Please expand on LOOP-UP.
Now there is a function called:
LOOKUP...in that case it has the structure of:
LOOKUP(lookup_value,lookup_vector,result_vector)
lookup_value is what you are looking for like "5".
lookup_vector is the cells or range of cells you wish to look for your value A1:A6
result_vector is the cells or range of cells you wish to display once it finds a match in the previous array B1:B5
So, if we use the following data table:
A1 B1
1 Red
3 Blue
5 Green
and apply the following in cell Z1=LOOKUP(5, A1:A3,B1:B3)
would return the Word Green In Cell Z1.
I hope this is what you were asking.
Please post back.
I am not certain I understand you question. Please expand on LOOP-UP.
Now there is a function called:
LOOKUP...in that case it has the structure of:
LOOKUP(lookup_value,lookup_vector,result_vector)
lookup_value is what you are looking for like "5".
lookup_vector is the cells or range of cells you wish to look for your value A1:A6
result_vector is the cells or range of cells you wish to display once it finds a match in the previous array B1:B5
So, if we use the following data table:
A1 B1
1 Red
3 Blue
5 Green
and apply the following in cell Z1=LOOKUP(5, A1:A3,B1:B3)
would return the Word Green In Cell Z1.
I hope this is what you were asking.
Please post back.
