matching values
Sorry about the delay in getting back, it took me a while to work out a formula as i'm no expert by any means, i just like to try to give something back to the forum for all the help i've had..................that said..........copy and paste this in to cell b1 then copy down, it worked for me! =IF(ISERROR(MATCH(A1,C:C,0)),"",VLOOKUP(A1,C:D,2,F ALSE)) Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=552076 |
All times are GMT +1. The time now is 09:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com