Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching two values | Excel Worksheet Functions | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
matching values | Excel Worksheet Functions | |||
matching values | Excel Programming | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming |