Hey guys,
at the moment i have a spreadsheet with this formula in a cell
(vlookupneg is vba so it looks to the left of the H column and works fine)
=IF(VLOOKUPneg(C3,'Batch'!H:H,-4,FALSE)<>"",VLOOKUPneg(C3,'Batch'!H:H,-4,FALSE),VLOOKUPneg(C3,'Batch'!H:H,-5,FALSE))
the above looks at a cell, matches C3 on sheet Batch, and pulls the data from -4 if it exists, or from -5 if theres nothing in -4
is there a way of adding another cell (E17) on the original sheet (where C3 is) so that if there is something in E17 it will be used instead of the two that are currently in use (-4 / -5) ?
thanks in advance!
at the moment i have a spreadsheet with this formula in a cell
(vlookupneg is vba so it looks to the left of the H column and works fine)
=IF(VLOOKUPneg(C3,'Batch'!H:H,-4,FALSE)<>"",VLOOKUPneg(C3,'Batch'!H:H,-4,FALSE),VLOOKUPneg(C3,'Batch'!H:H,-5,FALSE))
the above looks at a cell, matches C3 on sheet Batch, and pulls the data from -4 if it exists, or from -5 if theres nothing in -4
is there a way of adding another cell (E17) on the original sheet (where C3 is) so that if there is something in E17 it will be used instead of the two that are currently in use (-4 / -5) ?
thanks in advance!