Hello All:

I have a lookup problem, I hope you can help.

I would like to lookup cells in a column in sheet 1 in a range in shee
2, if they don't match exactly, I want it to return the contents of th
cell reference in sheet 2, if they match, it should show a blank cell.

I started if off as follows, but I was getting a N/A:

=IF(VLOOKUP(E2,MBAN,13,0)<E2,VLOOKUP(E2,MBAN,13,0 ),"")

Thanks a lot.

RichardO

--
Message posted from http://www.ExcelForum.com