Hi all,

I have the following formula:

=IF(VLOOKUP(A2,HUB.xls!interserve,2,FALSE),(VLOOKUP(A2,HUB.xls!interserve,24,FALSE)-14),"")

What I'm trying to do is run a VLOOKUP in the file HUB.xls first looks for a specific ID number. If this ID number is there, I then want Excel to look in the 24th column of HUB.xls (the range being 'interserve') and subtract 14 from it. I thought that the above formula would do it, but no. Just what I need on aFriday afternoon!!!

Can anyone suggest where I'm going wrong?

TIA,

SamuelT