Niek,
In that case what do you think is the better formula, COUNTIF or
VLOOKUP?

--JP

On Oct 20, 10:40 am, "Niek Otten" wrote:
Note that the OP looks up in 1 column only....

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JP" wrote in ooglegroups.com...

| Hi Max,
|
| I think what you meant was =IF(COUNTIF(data!B$3:B
| $52,B57),VLOOKUP(B57,'data'!B$3:E$52,1,FALSE),"")
|
| ?
|