I want to find a value (2325541) but I have to find it in a cell that has multiple numbers, and return a number in a different cell. The VLOOKUP would look like this: =VLOOKUP(A3,'[5.5.14.csv]5.5.14'!$D$846:$E$846,2,FALSE) but since D$846 looks like the example below (having multiple PO's in one cell) I get a #N/A return. Any help/suggestions appreciated!
"PO#2325557
PO#2325546
PO#2325558
PO#2325555
PO#2325537
PO#2325561
PO#2325541
PO#2325541
PO#2325553
PO#2331131"
http://www.excelforum.com/editpost.p...postid=3685183
Bookmarks