Hi All:
I keep getting an error when I try the following Vlookup formula.
I realize that if I change the formula so that the range is from E to F the and the index is 2 I will get the desired result. However, I need to understand why this formula won't work or is returning an error.
Thanks again for your help,
BA
I keep getting an error when I try the following Vlookup formula.
Book1 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
1 | |||||||
2 | |||||||
3 | 650000 | 650000 | TRUE | ||||
4 | |||||||
5 | #N/A | ||||||
Sheet1 |
I realize that if I change the formula so that the range is from E to F the and the index is 2 I will get the desired result. However, I need to understand why this formula won't work or is returning an error.
Thanks again for your help,
BA