houseofharts
New Member
- Joined
- Jan 20, 2014
- Messages
- 16
Hi all,
Another novice question. I am using the following
and it works great, except that the data returned is off by one row. For example, the correct value for the sample name in B107 is located in G107, but the formula returns the value in cell G106. I've tried changing the TRUE to FALSE and that returns #N/A.
Thanks in advance for any thoughts.
Another novice question. I am using the following
Code:
=VLOOKUP((LEFT(C4,6)),'Data from 7500'!$B$16:$G$195,6,TRUE)
and it works great, except that the data returned is off by one row. For example, the correct value for the sample name in B107 is located in G107, but the formula returns the value in cell G106. I've tried changing the TRUE to FALSE and that returns #N/A.
Thanks in advance for any thoughts.