Maybe a series of =vlookup()'s can be used to bring your data back:

with Vi123 in A2 of Sheet2
and your table in Sheet2 (Vi123/45 somewhere in column A)

=vlookup(a2&"*",sheet2!a:e,5,false)

will bring back the value in column E when

"chris.howes" wrote:

i have 2 sheets that contain various data they have a a field in common
but they do not match completly

i need to import sheet 1 data to sheet 2

sheet 1 data is in the fomat VI123/45 sheet 2 data is V123

how can i get excel to look at sheet 2 data and import the compleat
number from sheet 1

thnx in advance

--
chris.howes
------------------------------------------------------------------------
chris.howes's Profile: http://www.excelforum.com/member.php...fo&userid=5660
View this thread: http://www.excelforum.com/showthread...hreadid=548905

--

Dave Peterson