Formula question

[lomerick]

Hi,

Is it possible to combine this two formula into 1?

=VLOOKUP(C2,$J$1:$L$3095,3,0)

=IF(OR(F2="F6P 430",F2="F5P 420"),IF(ISERROR(FIND(("B"),D2,1)+FIND(("G"),D2,1)),"Pending","Done"),IF(OR(F2="A6P 430",F2="ANP 430"),IF(ISERROR(FIND(("E"),D2,1)+FIND(("L"),D2,1)+FIND(("V"),D2,1)),"No basic view",IF(ISERROR(FIND(("B"),D2,1)+FIND(("G"),D2,1)),"Pending","Done"))))


As you can see the first formula looks up the value, the second formula tags a specific status. I'm running this two formula with 600K rows and it takes long time to finish.

If ever what can you suggest me to do to make it faster?

Please Help me. Thanks

 

[MandeepBaluja]

upload your sheet with some data not all

 

[mubashiraziz]

Can you be more specific by posting some data in rows and columns and also let us know where you are using vlookup in other formula ?

 

[lomerick]

Pls let me know it this link works. Thanks

https://drive.google.com/open?id=0B-NVFHne9EdqRVVfZFh2Zzk5Rnc

 

[lomerick]

What I'm aiming to do is call it form another worksheet to save me calculation time.

 

[mubashiraziz]

Pls let me know it this link works. Thanks

https://drive.google.com/open?id=0B-NVFHne9EdqRVVfZFh2Zzk5Rnc

Unfortunately google accounts or any email account is banned in our office.

 

[MandeepBaluja]

request for access

 

[lomerick]

where can I upload???

 

[lomerick]

request for access

https://drive.google.com/file/d/0B-NVFHne9EdqRVVfZFh2Zzk5Rnc/view?usp=sharing

Pls try this it is shared now.

 

[lomerick]

Or if possible how to translate this to macro?