You are a star!!! thanks very much I am sorted now!

Steve

"T. Valko" wrote:

One way, assuming the lookup_value will *only* be in the first column of the
lookup_table.

=IF(A2="","",VLOOKUP(A2,IF(COUNTIF(Look,A2),Look,I F(COUNTIF(Look2,A2),Look2,Look3)),2,0))

--
Biff
Microsoft Excel MVP


"SteveH" wrote in message
...
Hi there, it won't be its a part list with each item appearing once

"Pecoflyer" wrote:


And what happens if the result is found in more than one range?


--
Pecoflyer

Cheers - MS Excel Newbie
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=43356