Brilliant! Could someone just explain to me how it works? - I haven't used
Vlookup before, and what does ISNA stand for?
Thanks

"JE McGimpsey" wrote:

You're missing a paren. Try

=IF(ISNA(VLOOKUP(C4,'Other Committees schedules'!C4:D3500,2,FALSE)),
"", VLOOKUP(C4,'Other Committees schedules'!C4:D3500,2,FALSE))

In article ,
"Lisa" wrote:

That doesn't seem to work - it;'s bringing up 'error' and highlighting the "
" section in the formula. I typed in:
=IF(ISNA(VLOOKUP(C4,'Other Committees schedules'!C4:D3500,2,FALSE),"
",VLOOKUP(C4,'Other Committees schedules'!C4:D3500,2,FALSE))

With C4 being the 1st reference number in column C and D3500 being the last
price refernce number...
Any suggestions?