Solved: Worksheet function help

[austenr]

What I am looking for is a function (MATCH) to look at the entry in column B then
try to match that number by looking at all of the entries in column A. If a macth
is found, place that number next to the number in column B. If there is no match
the cell should be left blank or say no match. A sample spreadsheet is attached.

Thanks everyone.

[Shazam]

Place this formula in C1 and copy it down.

=IF(ISERROR(VLOOKUP(B1,A$1:A$10,1,0)),"No Match",VLOOKUP(B1,A$1:A$10,1,0))

[austenr]

thanks solved

[Zack Barresse]

For other approaches, see here: http://www.mrexcel.com/board2/viewtopic.php?t=62102