OK first let me tell you what I have, and thank you if you can help;
Excel 2010
Single workbook with 2 Sheets
Let me give a more simple example
Sheet 1
A / B / C / D / E / F
1 Ran 34 45 49 (Formula) <---- Searches Sheet 2 column A for this Rows B column (Ran) finds any partial match (Orange) and returns the value of that rows H column (75)
2 Rack 33 34 50 (Formula) <---- Same thing here so it looks for a partial match with "Rack" which finds "Track" and returns "66"
3 Dog 31 30 50 (Formula)
Sheet 2
A / B / C / D / E / F / G / H
Tree Cat 233 300 21 20 15 59
Frog Cat 233 300 21 20 15 77
Track Cat 233 300 21 20 15 66
Orange Cat 233 300 21 20 15 75
Free Bit 233 300 21 20 15 65
Bookmarks