Hi,
I have a list of data and I want to use Vlookup to compare it to another list. Is it possible to use range of data as the lookup_Value?
For example, one list is blue, red, green, yellow, purple.
The other list is the car is green, the car is yellow, the phone is purple, the sky is blue, the fire is red.
I want to find the color in each sentence. Can I input a formula that will allow me to search one cell with the 5 lookup values and return the correct color?
This will save me a lot of time rather than looking for all cells that contain blue, red, etc. one byone.
I have a list of data and I want to use Vlookup to compare it to another list. Is it possible to use range of data as the lookup_Value?
For example, one list is blue, red, green, yellow, purple.
The other list is the car is green, the car is yellow, the phone is purple, the sky is blue, the fire is red.
I want to find the color in each sentence. Can I input a formula that will allow me to search one cell with the 5 lookup values and return the correct color?
This will save me a lot of time rather than looking for all cells that contain blue, red, etc. one byone.