thedeadzeds
New member
- Joined
- Oct 25, 2011
- Messages
- 37
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
For some reason my look up formula is not working. This is what I am trying to achieve. |
I have 2 tables, 1 named Database and the other Respond. |
I want to look up the values in Column H and check if they are in the Database Table. |
I have created lookups in columns I, J and K and coulmn I works fine, but I cant seem to get J and K to work properly. |
Ideally, I want to have just one vlookup in column I that can look up the value in column H and check if they are in any of the columns in the Database Table. |
I have tried this formula but it does not work. |
=VLOOKUP(H7, C$6:E$29, {1,2,3}, FALSE) |
Can someone please help? |
I have attached the file. |
Many thanks |