Assuming the Price returned of 284.05 is in say C2 then
I'm slightly confused since your original post says that the supplier names are in column J yet the Maintenance Register shown in your last post is column T.
If this is not giving the answer yo want you cn upload a file by choosing Go Advanced and looking for the Manage Attachments underneath the posting area.
The formula above is not isela since it uses whole column references which should usually be avoided since with some formulae and if there are large numbers of rows there will be an increase in time. In general always use specific ranges, e.g. MATCH(C2,X1:X100,....etc.
Better still get into the habit of using dynamic range names if the the rows of the underlying data increases as you add new stuff. A dynamic range name in the formula automatilyl adjusts the range being searched and you dont have to worry about editing formulae.
Bookmarks