Quote:
Originally Posted by Mazzaropi
HELP from BRAZIL <<<<<
Dear caverchik, Good Afternoon.
I believe that you can manage the two situations on the same formula without transform the formula into a nightmare.
Try this one:
=IF(ISTEXT(A302),VLOOKUP(LEFT(A302,4),ModelName!$A $2:$D$2001,3,FALSE),VLOOKUP(VALUE(LEFT(A302,4)),Mo delName!$A$2:$D$2001,3,FALSE))
Adapt the range or cells to your reality, if necessary.
Tell me it it worked for you.
|
It worked for a majority of the fields. It did not work for some of them, and there doesn't seem to be a pattern as to what those were. I'll work at it some more. Thank you!
Similar Threads
Threaded Mode
