Look Up Lat Entry or Revert to Previous Last Entry

[mycon73]

Hi,

I have 2 rows with cash balances

If on my 2nd is blank all the way across, because date or has not occurred, then the row is blan,


I'm trying to use this function if row 2 (P46:V46) has no data entries, then it will revert previous data entry or Y39
=IF(LOOKUP(9.99E+307,P46:V46)=0,Y39,LOOKUP(9.99E+307,P46:V46))

Right now this function is resulting, with, "#N/A".

How to avoid & get to show value in Y39

Thanks

[Vikas_Gautam]

Need More Info....!
Probably posting a sample workbook may help....

[boopathiraja]

May be try this ,

=IFERROR(LOOKUP(9E+99+307,P46:V46),Y39)

[mycon73]

Hi boopathiraja,


This function works great!!

Thanks