Excel 2007 : Find data from another sheet with partial value

[fentontech]

I have 2 worksheets

sheet(report)

A1 is the search criteria and C1 is the search result (C1 needs the formula)
--------a------------b-------------c--------------d-
1--1120-------name-------$1596
2
3
4


Sheet(Data)

A1 contains the data to be searched (notice that the name is combined with the search criteria) and B1 has the data i want returned to C1 on sheet(report)
--------a--------------------b-------------c--------------d-
1--1120 name------$1596----------0-------------empty
2
3
4

thank you for looking at this!!!

[ConneXionLost]

In cell 'Data'!A1, do you have a space between "1120" and "name"?

[fentontech]

yes there is a space. and some times the number could be 1120.1

[ConneXionLost]

In cell 'report'!C1, try:

Please Login or Register  to view this content.

Adjust range as required.

[fentontech]

the name field may have small differences in them so I cant use that.... is there a way to just look to see if the target contains the criteria and then return the target