Hi Simon, how about if(isnumber(a14)=true,vlookup
(a14,XXXXX,X),"")?

John
-----Original Message-----
Hi all,

Iwas just wondering if someone could help me with vb code
that inserts
a 'vlookup' formulae in Col B14 onwards only if there is
a numeric
value in Col A14 and onwards

ie. I want to press an active X button and have Col A14
to Ax filled
with data from sheet 2 and then look up the corresponding
values from
sheet 1 using vlookup.


Cheers,
Simon


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

.