Hello,
I need to be able to match a number in cell I2 exactly to a number in cell D3 that is contained in a text string. If the match is true then the formula needs to return a value contained in cell H3. The problem is all the functions I have tried do not distinguish between similar numbers (for instance 34 and 344) so the results of these numbers are being duplicated in each of the relevant columns. The current formula I am using is:
=IF((ISERROR((SEARCH(" "&I$2,$D3))))=TRUE,"",$H3)
I have attached a jpg of a portion of my spreadsheet.
Any help would be greatly appreciated.
Kind regards
Jane
Bookmarks