View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TobbeGardner TobbeGardner is offline
external usenet poster
 
Posts: 1
Default Lookup of identical values?


Hi,

I am sorry, I was not clear enought...
123 is in one column A and 1 or 2 is in column B.

Your solution, if I understand it, works fine if I was looking for
"123,1" in a single cell.

Is there away to solve the problem with the data in different columns?

Regards,
Tobbe G


--
TobbeGardner
------------------------------------------------------------------------
TobbeGardner's Profile: http://www.excelforum.com/member.php...o&userid=35924
View this thread: http://www.excelforum.com/showthread...hreadid=557192