I've gone through all the posts where people are trying to look up by numbers and have problems where it's a text field and should be reformatted to a number. Here's my issue:
I have a text field (B2052AG1-JOB00187) that needs to be run against column 2 in my range. Upon a match, I need column 1 (Date) returned.
=VLOOKUP (C3,SampleRange,1, False)
I've used VLookup before using a text field and returning a number. However, I'm not sure what's going on now. (Maybe the first time it was a fluke ;-)
Any other function I should use for text matches? I've been spinning my wheels on this for quite some time.
Thanks,
I have a text field (B2052AG1-JOB00187) that needs to be run against column 2 in my range. Upon a match, I need column 1 (Date) returned.
=VLOOKUP (C3,SampleRange,1, False)
I've used VLookup before using a text field and returning a number. However, I'm not sure what's going on now. (Maybe the first time it was a fluke ;-)
Any other function I should use for text matches? I've been spinning my wheels on this for quite some time.
Thanks,