Hi, I'm trying to develop a report which looks at two columns of part numbers which have a corresponding prices in a third column. The first column is imported and can vary from month to month. The second column is for reference and is static. This is the formula I've got which only partially works (don't know why it sometimes works and sometimes not??). Column C contains the prices and I want to match Column A with Column B
=INDEX(C1:C385,MATCH(A2,B1:B500,1)).
Been on this for nearly 3 days and if I had any, I'd have pulled my hair out by now!! Any help will be appreciated.
Many thanks
Bookmarks