Vlookup problem
Well, it's a bit messy, but you could do this:
=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,0)),"",I F(VLOOKUP($A7,BB!$A
$1:$S$5000,5,0)="","",VLOOKUP($A7,BB!$A$1:$S$5000, 5,0)))
Hope this helps.
Pete
On Oct 13, 2:05*am, Debbie wrote:
On Oct 12, 9:04*pm, Debbie wrote:
Hi!
The problem I am having is in the lookup table, sometimes row 5 is
empty. When it is, it puts a zero in my cell. I want it to be blank.
Can I do this? I have pasted my formula.
=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,FALSE)), "",VLOOKUP($A7,BB!$A
$1:$S$5000,5,FALSE))
Sorry, column 5 not row 5
|