G
Guest
For the following array which has been named "test":
1 a
2 b
3 c
4 d
5 e
I wrote the following if and lookup functions in cell A1, "=IF(A2 = " ", "
", VLOOKUP(A2, test, 2, FALSE))". What I want is Cell A1 to return a value
from the "test" array. For example, "a" should be returned when 1 is entered
in A1. Also, I want A1 to be blank when A2 is blank. The vlookup is working
fine but when A2 is blank, A1 is showing "#N/A". Tried everything but nothng
works. Please help.
Thanks!
1 a
2 b
3 c
4 d
5 e
I wrote the following if and lookup functions in cell A1, "=IF(A2 = " ", "
", VLOOKUP(A2, test, 2, FALSE))". What I want is Cell A1 to return a value
from the "test" array. For example, "a" should be returned when 1 is entered
in A1. Also, I want A1 to be blank when A2 is blank. The vlookup is working
fine but when A2 is blank, A1 is showing "#N/A". Tried everything but nothng
works. Please help.
Thanks!